Hi

I have a service flow in IS 10.5 using JDBC adapter. It’s working fine when running it as standalone service.
However, it fails when invoking it from a BPM process service, it can’t find the SQL driver… any thoughts ?

Thanks
Julien

[44501]2020-06-02 16:55:11 CEST [BPM.0102.0199I] 20969ade-206a-48af-84fe-1b57f6095f44:1, MID=BPM_Zitouna/Sinitre, MVer=1: process failed
[44500]2020-06-02 16:55:11 CEST [BPM.0102.0376E] 20969ade-206a-48af-84fe-1b57f6095f44:1, S38: exception invoking service BPM_Zitouna.Sinitre.Sinitre_1.Default:Expertise_Sinistre: [PRT.0101.9125] Service BPM_Zitouna.Sinitre.Sinitre_1.Default:Expertise_Sinistre failed.
[44499]2020-06-02 16:55:11 CEST [BPM.0102.0002E] Exception: com.wm.app.prt.ProcessException
[44498][Microsoft][SQLServer 2000 Driver for JDBC]The specified SQL type is not supported by this driver.
44497 [Microsoft][SQLServer 2000 Driver for JDBC]The specified SQL type is not supported by this driver."
[44496][ADA.1.316] Cannot execute the SQL statement “INSERT INTO JDE.dbo.PPM(ProcessID, ActivityName, ActivityStart, ActivityEnd, RequestedBy) VALUES (?, ?, ?, ?, ?)”. "
[44495]2020-06-02 16:55:11 CEST [ART.0114.1007E] Adapter Runtime: Error Logged. See Error log for details. Error: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service julien.adapters:insert with connection julien:SQLserver.
44494 [Microsoft][SQLServer 2000 Driver for JDBC]The specified SQL type is not supported by this driver."<<<,detail=>>>BasicData:insertInput=>>>BasicData:ProcessID=10001,ActivityName=Expertise Sinistre,ActivityStart=02.06.20 16:55:11:741,ActivityEnd=02.06.20 16:55:11:741<<<,PPM_Pivot=>>>BasicData:ProcessID=10001,ActivityName=Expertise Sinistre,ActivityStart=02.06.20 16:55:11:741,ActivityEnd=02.06.20 16:55:11:741<<<,Trigger_Expert=>>>BasicData:Requester=Julien,_env=>>>BasicData:activation=wm6d4ef4e35-a30b-4dbd-bbb1-0531fb8b9931,businessContext=wm6:32d1dbd0-fcd1-49b7-9654-a561d4c30ffe\snull\snull:wm6d4ef4e35-a30b-4dbd-bbb1-0531fb8b9931:null:IS_61:null,locale=,pubId=J_jRQtEolDEurgAVIwwwADXaZQs__DefaultClient,uuid=wm:0f219f40-a4e1-11ea-88b4-00000000000b,eventID=22,recvTime=Tue Jun 02 16:55:11 CEST 2020<<<<<<,ProcessData=>>>BasicData:PRTInternal=>>>BasicData:PubDocs=>>>BasicData:Trigger_Expert=PRT<<<<<<,LastEvents=>>>BasicData:PRTEvents=>>>BasicData:instanceId=20969ade-206a-48af-84fe-1b57f6095f44:1,modelId=BPM_Zitouna/Sinitre,modelVersion=1,targetStepId=S38,trackCount=1,sourceStepId=S33,serverId=Default,deadPath=false,inputExec=true<<<<<<,tmdModelId=BPM_Zitouna/Sinitre,tmdTargetStepId=S38,tmdSourceStepId=S33,ProcessInstanceID=20969ade-206a-48af-84fe-1b57f6095f44,ProcessIteration=1,ProcessModelID=BPM_Zitouna/Sinitre,ProcessModelVersion=1,ProcessStepID=S38,TryCount=1,LoopCounter=0,LogicalServer=Default<<<<<<,errorCode=117.4002,errorMessageArgs=[Ljava.lang.String;@21ded924,errorResourceBundleName=com.wm.pkg.art.i18n.resources.AdapterRuntimeResourceBundle}
[44493],exceptionClass=java.sql.SQLException,reason=[Microsoft][SQLServer 2000 Driver for JDBC]The specified SQL type is not supported by this driver.,serviceCallStack=[0]wm.prt.dispatch:handlePublishedInput,[1]BPM_Zitouna.Sinitre.Sinitre_1.Default:Expertise_Sinistre,[2]julien.utils:Expertise_Sinistre,[3]julien.adapters:insert,sessionName=BPM_Zitouna.Sinitre.Default:subscriptionTriggerwm:0f219f40-a4e1-11ea-88b4-00000000000b,sessionId=dc7a16a4612d403094bab2abf5767741,date=Tue Jun 02 16:55:11 CEST 2020,service=julien.adapters:insert,message=Cannot execute the SQL statement “INSERT INTO JDE.dbo.PPM(ProcessID, ActivityName, ActivityStart, ActivityEnd, RequestedBy) VALUES (?, ?, ?, ?, ?)”. "

can be a data issue. I don’t see a value for: RequestedBy in the log. try to save the pipeline before calling the service to see if all inputs have value.