Solved: Error when try to export Rule to Data Services Rep...

hi Guys,

Actually I use this platforms:

- SAP DS 4.2 SP5

- SAP IPS 4.1 SP5

- SAP Information Steward 4.2 SP5

I choose one connection to my SAP IQ and working with that, made some test rules in Information Stewards and create it. But when i try to export to a Data Services Repository the next error appear:

btw, my DSRepo its in SQLAnywhere12 and its work perfectly in DS Designer also. I dont use ODBC connection to it, I just use the native one.

What its the possible cause of this error ? or maybe a workaround ?

Thank you in advances and regards,

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (1)

In what way did you export it to DS Repo?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi,

via web in Information steward rule export.

When i try to EXPORT the error message appear.

1) Is your local repo is created with fully qualified name in server name? If not give a try ( because - in general the below errors will occurs in case if full qualify name is not given

[ DBS-070401: Initialization ODBC data source <> error message for operation <SQLAllocStmt>: <[Sybase][ODBC Driver]Connection not open>.(14.2) 01-30-16 18:48:06 (E) (5891:2161315744) DBS-070401: Initialization ODBC data source <> error message for operation <SQLAllocStmt>: <*****>. This message contains some internal system details ]

2) Try export the same to .atl file and manually import it in DS

Hi,

this fully qualified name i need to change in CMC or in Job Server level ?

First change at CMC and see if it can resolve or not.Other wiase try at job server also!

Is your issue is fixed?

Sap support confirm me that this issue will attached to fixed in a next fixpack, maybe at the end of this month.

here the KBA about it: 2277691 -Error exporting rules from Data Insight to Data Services SQL Anywhere 12 repository

Thanks for the note, Is the .atl work around is success? ( 2. Try export the same to .atl file and manually import it in DS).

Answers (1)

Do you have more information?. Export log , may be?. Looks like the the connection is not established

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Magesh,

Sure now I attached two logs in Logging directory.

btw, DSREPO connection in the CMC/ DataServices looks like this:

the connection its Active to the DSREPO and when i test, was success connected. But in the Information Steward the error still appear.

[E] 2016-01-30 18:48:06.370 [ApplicationService][Transport:Shared-363/34] Data Services execution failed for [-f"/sapmnt/sap_bobj/enterprise_xi40/java/pjs/container/temp/testenvds42.EIMAdaptiveProcessingServer/is_8671762542335028824649666086398212487.atl", -passphrase4853855133431684571292272561499877729, -KimportTran]. Error :

(14.2) 01-30-16 18:48:06 (R) (5891:2161315744) DBS-070401: Initialization ODBC data source <> error message for operation <SQLAllocStmt>: <[Sybase][ODBC Driver]Connection not open>.(14.2) 01-30-16 18:48:06 (E) (5891:2161315744) DBS-070401: Initialization ODBC data source <> error message for operation <SQLAllocStmt>: <*****>. This message contains some internal system details which have been hidden for security. If you need to see the full contents of the original message, ask your administrator to assign additional privileges to your account. (COR-10690)

[E] 2016-01-30 18:48:06.370 [ApplicationService][Transport:Shared-363/34] com.bobj.mm.sdk.SDKException: Data Services execution failed for [-f"/sapmnt/sap_bobj/enterprise_xi40/java/pjs/container/temp/testenvds42.EIMAdaptiveProcessingServer/is_8671762542335028824649666086398212487.atl", -passphrase4853855133431684571292272561499877729, -KimportTran]. Error :

at com.sap.is.service.AbstractTransportClient.dispatch(AbstractTransportClient.java:94)

at com.sap.icc.boe.plugin.service.adminservice.client.internal.AdminServiceTransportClient.exportDSObject(AdminServiceTransportClient.java:39)

at com.businessobjects.icc.profiling.services.common.ProfilingUtil.exportRule2DS(ProfilingUtil.java:204)

at com.sap.is.service.application.action.profiling.dataservices.ExportRulesToDataServices.execute(ExportRulesToDataServices.java:92)

at com.sap.is.service.application.server.ApplicationServiceImpl.processOperation(ApplicationServiceImpl.java:125)

at sun.reflect.GeneratedMethodAccessor92.invoke(Unknown Source)

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

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

at com.sap.is.service.AbstractTransportServer.dispatchUsingReflection(AbstractTransportServer.java:267)

at com.sap.is.service.AbstractTransportServer.dispatchMessage(AbstractTransportServer.java:176)

at com.sap.is.service.AbstractTransportServer.process(AbstractTransportServer.java:119)

at com.businessobjects.framework.servers.platform.transport.internal.TransportRequestInterceptor.process(TransportRequestInterceptor.java:128)

at com.crystaldecisions.sdk.occa.transport.internal.BIPTransportImpl.post(BIPTransportImpl.java:90)

at sun.reflect.GeneratedMethodAccessor56.invoke(Unknown Source)

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

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

at com.businessobjects.framework.servers.platform.adapters.ebus.orb.CommonTransportInterceptor.invokeHelper(CommonTransportInterceptor.java:118)

at com.businessobjects.framework.servers.platform.adapters.ebus.orb.CommonTransportInterceptor.invoke(CommonTransportInterceptor.java:87)

at com.businessobjects.framework.servers.common.proxy.cglib.MethodInterceptorChain.intercept(MethodInterceptorChain.java:136)

at com.crystaldecisions.enterprise.ocaframework.idl.OCA2.BIPTransportPOA$$EnhancerByCGLIB$$31dc1f51.post(<generated>)

at com.crystaldecisions.enterprise.ocaframework.idl.OCA2.BIPTransportPOA._OB_op_post(BIPTransportPOA.java:120)

at com.crystaldecisions.enterprise.ocaframework.idl.OCA2.BIPTransportPOA._invoke(BIPTransportPOA.java:87)

at com.crystaldecisions.thirdparty.com.ooc.OBPortableServer.ServantDispatcher.dispatch(ServantDispatcher.java:234)

at com.crystaldecisions.thirdparty.com.ooc.OBPortableServer.POA_impl._do_OB_dispatch(POA_impl.java:1980)

at com.crystaldecisions.thirdparty.com.ooc.OBPortableServer.POA_impl._OB_dispatch(POA_impl.java:1916)

at com.crystaldecisions.thirdparty.com.ooc.OB.DispatchRequest_impl.invoke(DispatchRequest_impl.java:122)

at com.businessobjects.framework.servers.platform.adapters.ebus.orb.ThreadPoolDispatchStrategy$Dispatcher.run(ThreadPoolDispatchStrategy.java:271)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)

at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)

at java.util.concurrent.FutureTask.run(FutureTask.java:138)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)

at java.lang.Thread.run(Thread.java:763)

more logs lines:

I] 2016-01-30 18:56:35.092 [AdminService][Transport:Shared-1/34] Export Rules: [DSRulesExport:ProjectId:4768, dsRepositoryId:bb7f3dad-2f75-4935-b8a7-4b5292fcf5e3, rules:[com.sap.icc.boe.plugin.service.adminservice.client.Rule@2d3e5702], exportDependents:false]

[I] 2016-01-30 18:56:35.396 [AdminService][Transport:Shared-1/34] Finished exportDSObject() [DSRulesExport:ProjectId:4768, dsRepositoryId:bb7f3dad-2f75-4935-b8a7-4b5292fcf5e3, rules:[com.sap.icc.boe.plugin.service.adminservice.client.Rule@2d3e5702], exportDependents:false] with errors

[E] 2016-01-30 18:56:35.396 [AdminService][Transport:Shared-1/34] Data Services execution failed for [-f"/sapmnt/sap_bobj/enterprise_xi40/java/pjs/container/temp/testenvds42.EIMAdaptiveProcessingServer/is_8671762542335028841401479487303733455.atl", -passphrase10454493481322023711529557899054579531, -KimportTran]. Error :

(COR-10690)

[E] 2016-01-30 18:56:35.397 [AdminService][Transport:Shared-1/34] com.bobj.mm.sdk.SDKException: Data Services execution failed for [-f"/sapmnt/sap_bobj/enterprise_xi40/java/pjs/container/temp/testenvds42.EIMAdaptiveProcessingServer/is_8671762542335028841401479487303733455.atl", -passphrase10454493481322023711529557899054579531, -KimportTran]. Error :

(COR-10690)

at com.sap.icc.boe.plugin.service.adminservice.server.AdminServiceServer.executeOperationCommand(AdminServiceServer.java:198)

at com.sap.icc.boe.plugin.service.adminservice.server.AdminServiceServer.exportDSObject(AdminServiceServer.java:130)

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 com.sap.is.service.AbstractTransportServer.dispatchUsingReflection(AbstractTransportServer.java:267)

at com.sap.is.service.AbstractTransportServer.dispatchMessage(AbstractTransportServer.java:176)

at com.sap.is.service.AbstractTransportServer.process(AbstractTransportServer.java:119)

at com.businessobjects.framework.servers.platform.transport.internal.TransportRequestInterceptor.process(TransportRequestInterceptor.java:128)

at com.crystaldecisions.sdk.occa.transport.internal.BIPTransportImpl.post(BIPTransportImpl.java:90)

at sun.reflect.GeneratedMethodAccessor56.invoke(Unknown Source)

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

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

at com.businessobjects.framework.servers.platform.adapters.ebus.orb.CommonTransportInterceptor.invokeHelper(CommonTransportInterceptor.java:118)

at com.businessobjects.framework.servers.platform.adapters.ebus.orb.CommonTransportInterceptor.invoke(CommonTransportInterceptor.java:87)

at com.businessobjects.framework.servers.common.proxy.cglib.MethodInterceptorChain.intercept(MethodInterceptorChain.java:136)

at com.crystaldecisions.enterprise.ocaframework.idl.OCA2.BIPTransportPOA$$EnhancerByCGLIB$$cd8d8424.post(<generated>)