Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, i was working on executing a cmd prompt command to take a backup of postgresql database using tSystem. Before that i was trying to run simple commands using tSystem [Use Array command]. But I'm getting error like this:
Error Line: 359
Detail Message: Syntax error on token "=", Expression expected after this token
There may be some other errors caused by JVM compatibility. Make sure your JVM setup is similar to the studio.
at org.talend.designer.runprocess.JobErrorsChecker.checkLastGenerationHasCompilationError(JobErrorsChecker.java:359)
at org.talend.designer.runprocess.DefaultRunProcessService.checkLastGenerationHasCompilationError(DefaultRunProcessService.java:534)
at org.talend.designer.runprocess.RunProcessService.checkLastGenerationHasCompilationError(RunProcessService.java:318)
at org.talend.designer.runprocess.ProcessorUtilities.generateBuildInfo(ProcessorUtilities.java:826)
at org.talend.designer.runprocess.ProcessorUtilities.generateCode(ProcessorUtilities.java:706)
at org.talend.designer.runprocess.ProcessorUtilities.generateCode(ProcessorUtilities.java:2029)
at org.talend.designer.runprocess.RunProcessContext$2.run(RunProcessContext.java:663)
at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:436)
at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:352)
at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:468)
at org.eclipse.ui.internal.progress.ProgressMonitorJobsDialog.run(ProgressMonitorJobsDialog.java:228)
at org.eclipse.ui.internal.progress.ProgressManager.run(ProgressManager.java:984)
at org.talend.designer.runprocess.RunProcessContext.exec(RunProcessContext.java:610)
at org.talend.designer.runprocess.ui.ProcessComposite.exec(ProcessComposite.java:1447)
at org.talend.designer.runprocess.ui.views.ProcessView$RunAction.run(ProcessView.java:736)
at org.talend.designer.runprocess.ui.actions.RunProcessAction.run(RunProcessAction.java:63)
at org.talend.designer.core.debug.JobLaunchConfigurationDelegate$1$1.run(JobLaunchConfigurationDelegate.java:98)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:40)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:185)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4001)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3629)
at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$5.run(PartRenderingEngine.java:1157)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:338)
at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1046)
at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:155)
at org.eclipse.ui.internal.Workbench.lambda$3(Workbench.java:644)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:338)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:551)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:156)
at org.talend.rcp.intro.Application.start(Application.java:303)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:203)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:401)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:255)
at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)
at java.base/java.lang.reflect.Method.invoke(Method.java:577)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:654)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:591)
at org.eclipse.equinox.launcher.Main.run(Main.java:1462)
Can anyone help me with this ?
Also will i be able to take a backup of postgresql database using tSystem component ?
Hello @Soumya M ,
Regarding to the error log, seems there is some wrong with your "Use Array Command" settings in tSystem.
Please refer to the below article
https://help.talend.com/r/en-US/8.0/system/executing-cmd-with-multiple-para-using-tsystem-procedure
if it doesn't help, please provide a snapshot of your tSystem component settings
Also, Yes, I think it's ok to take a backup of postgresql db by tSystem
I did it in my side by using pg_dump cmd, and it's working like the below
NOTE: it need to setup pg_dump command path to the System environment PATH first and need to restart the studio
can you give me the syntax of this command achen ?
Hello @Soumya M ,
It's something like
pg_dump postgresql://<user>:<passwd>@<db_host>:<port>/<db_name>
e.g.
"pg_dump postgresql://postgres:Talend123@localhost:5433/test"