Data Services Workbench - Connections with external database

[Former Member]

Hello there

I am trying to connect my DS workbench with a MSSQL database and get the following error - from the log.

What could be wrong?

My ODBC connections are testing ok and connections from Data Services Designer - datastore is working fine as well.

-----------------------------------------------------------------

javax.xml.stream.XMLStreamException: ParseError at [row,col]:[1,1]

Message: Premature end of file.

          at com.sun.org.apache.xerces.internal.impl.XMLStreamReaderImpl.next(XMLStreamReaderImpl.java:594)

          at com.sap.dataservices.designer.services.metadata.impl.MetadataServiceHelper.parseTestConnectionResponse(Unknown Source)

          at com.sap.dataservices.designer.services.metadata.impl.MetadataServiceImpl.testConnection(Unknown Source)

          at com.sap.dataservices.designer.datastore.actions.TestConfigurationAction.runChecked(Unknown Source)

          at com.sap.dataservices.designer.framework.actions.AbstractActionDelegate.run(Unknown Source)

          at com.sap.dataservices.designer.framework.actions.AbstractActionDelegate.run(Unknown Source)

          at com.sap.dataservices.designer.datastore.editor.properties.DataStoreConfigurationOptionsPropertyPart$3.widgetSelected(Unknown Source)

          at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:234)

          at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)

          at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)

          at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4066)

          at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3657)

          at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2640)

          at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2604)

          at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2438)

          at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:671)

          at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)

          at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:664)

          at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)

          at com.sap.dataservices.designer.rcp.Application.start(Unknown Source)

          at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)

          at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)

          at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)

          at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:369)

          at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)

          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

          at java.lang.reflect.Method.invoke(Method.java:597)

          at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:620)

          at org.eclipse.equinox.launcher.Main.basicRun(Main.java:575)

          at org.eclipse.equinox.launcher.Main.run(Main.java:1408)

[adil_madid]

I assume we are talking about DS 4.x ( which SP ? just as info for me )
Can you attached screenshots if possible the logs as txt files.
Based on your last comment it sound like the job ran successuly in designer but you get no data in your target table without error logged in the error log file.
Where the error seen in the description comes from ?
Thanks,

Adil

[Former Member]

Adil,  DS 4.1,..I think the workbench is beta so I think it may be bug. The main issue now is designer.

The log for workbench is in first post.

The Jobtracelog for designer is as follows

-----------------------------------

14.1) 04-04-12 16:17:11 (39756:3822241536)      JOB: The initial environment locale <eng_us.utf-8> has been coerced to <Unicode (UTF-16)> ().

(14.1) 04-04-12 16:17:12 (39756:3822241536)      JOB: Reading job <4b5a2304_d49a_4265_a0fb_5c1cf7968c21> from the repository; Server version is <14.1.0.340>; Repository version is

                                                      <14.1.0.0000>.

(14.1) 04-04-12 16:17:12 (39756:3822241536)      JOB: Current directory of job <4b5a2304_d49a_4265_a0fb_5c1cf7968c21> is </build/boe/dataservices/bin>.

(14.1) 04-04-12 16:17:12 (39756:3822241536)      JOB: Starting job on job server host <hanasvr-08>, port <3500>.

(14.1) 04-04-12 16:17:12 (39756:3822241536)      JOB: Job <New_Job6> of runid <20120404161712397563822241536> is initiated by user <boeuser>.

(14.1) 04-04-12 16:17:12 (39756:3822241536)      JOB: Processing job <New_Job6>.

(14.1) 04-04-12 16:17:13 (39756:3822241536)      JOB: Initializing transcoder for datastore <GTLNOPODBC> to transcode between engine codepage<Unicode (UTF-16)> and datastore

                                                      codepage <<DEFAULT>>

(14.1) 04-04-12 16:17:13 (39756:3822241536)   DB_LIB: Load odbc driver library </build/boe/dataservices/DataDirect/odbc/lib/libodbc.so>.

---------------------------------------

Now I see that  the Job which appeared green earlier is red today.

[Former Member]

Hi Anand,

Please open two separat tickets for this.

If you are included in the 4.1 ramp-up program (Ramp-Up = kind of beta where you are paying a dedicated resouce from SAP  called Ramp-up Coach to assist you in adoption the solution; I believe that Premium Customers can use their allocated training/consultant or TQM days for that ,but you would have to ask for more details http://www.sap.com/services/more/rampup/index.epx )

Then your tickets on this produts will also show ramp-up status and will be treated as such.
Ask your ramp-up coach if you have any doubt.

1) The workbench question definitely is a rampup question

2) The Designer issue looks like a lot of troubleshooting and error log reading.(the one you post looks OK.. and is on 4.1 - so it will receive ramp-up treatement)

Regards

Norbert

[Former Member]

Hi Anand ,

I am trying to connect my DS workbench with a MSSQL database and get the following error - from the log. <= means you are getting this when executing the job? On the same server or is the job engine on a different one?

My ODBC connections are testing ok and connections from Data Services Designer - datastore is working fine as well.<= means you have set up odbc connections on a windows system for MS-SQL Server? why? Can you see the data in the table content in the designer before executing the job?

Norbert

[Former Member]

Nobert

The DS workbench connection test fails and throws the erroor.

The ODBC connection with Designer was working, but additionally I cannot get the data from ECC to SQL or from SQL to SQL/ HANA. I can preview data with Designer, the jobs runs ok, with green flag but it says empty file in error log. the source table has data. The source and target tables have exact same structure.