tSystem

[Soumya_M]

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 ?

[Anonymous]

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

[Soumya_M]

can you give me the syntax of this command achen ?

[Anonymous]

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"