I have maven based interface, I need to connect the best MSBI online training database and fetch the data into the mule.
I have added the required jar sqljdbc42.jar to build the path.
PFB is the MSBI connection configuration:
SELECT [Cstmr_Acct_Id] AS SAP_Account_ID1<br /> ,[Accnt_Nm] AS CRM_Account_Name1<br /> ,[Accnt_Type] AS APL_Account_Attributes___Account_Type1<br /> ,[Cstmr_Sgmnt] AS CRM_Customer_Segment1<br /> ,[Trnprttn_role] AS CRM_Transportation_Role1<br /> ,CASE WHEN [Accnt_Stts]='A' THEN 'Active' WHEN [Accnt_Stts]='I' THEN 'Inactive' ELSE NULL END AS CRM_Account_Status1<br /> ,[Rgn] AS Region1<br /> ,[Rgn_desc] AS Region_Text1<br /> ,[Clster] AS Cluster1<br /> ,[Clster_desc] AS Cluster_Text1<br /> ,[Dstrct] AS District1<br /> ,[Dstrct_desc] AS District_Text1<br /> ,[Cntry] AS Country1<br /> ,[Cntry_desc] AS Country_Text1<br /> ,[Brnch] AS Branch1<br /> ,[Brnch_desc] AS Branch_Text1<br /> ,[Trrtry] AS Territory1<br /> ,[Trrtry_desc] AS Territory_Desc1<br /> ,[New_BT_Cd] AS BT_Code1<br /> ,[Lgcy_BT_Cd] AS Legacy_BTCode1<br /> ,[Last_Update_Dt] AS LAST_UPDATE_Date1<br /> FROM [dbo].[vw_elqa_CRM_Accnt_Sales_Hierarchy]<br /> WHERE<br />(<br /> CAST(Last_Update_Dt AS date) >= CAST(GETDATE() AS date) OR <br /> CAST(Last_Update_Dt AS date) >= CAST(#[server.systemProperties['mule.env']=='dev'?server.systemProperties['msbi.debug.csr.query.filterDate']:'2100-01-01'] AS date)<br />) AND Cstmr_Acct_Id IS NOT NULL
Getting the below error after adding a dependency
ERROR********************************************************************************Message : Response code 500 mapped as failure.Payload : org.glassfish.grizzly.utils.BufferInputStream@cb5d5afPayload Type : org.mule.module.db.internal.result.resultset.ResultSetIteratorElement : /MSBItoEloquaContactCDODataUpdate/input/0/0/EloquaLookupContactsCDOBulk/subprocessors/1/EloquaLookupFields/subprocessors/0/0/1/2 @ nol-integration-v1:bulk-integration.xml:92 (Eloqua Get CDO fields)Element XML : --------------------------------------------------------------------------------Root Exception stack trace:org.mule.module.http.internal.request.ResponseValidatorException: Response code 500 mapped as failure. at org.mule.module.http.internal.request.SuccessStatusCodeValidator.validate(SuccessStatusCodeValidator.java:37) at org.mule.module.http.internal.request.DefaultHttpRequester.validateResponse(DefaultHttpRequester.java:413) at org.mule.module.http.internal.request.DefaultHttpRequester.innerProcess(DefaultHttpRequester.java:401) at org.mule.module.http.internal.request.DefaultHttpRequester.processBlocking(DefaultHttpRequester.java:221) at org.mule.processor.AbstractNonBlockingMessageProcessor.process(AbstractNonBlockingMessageProcessor.java:43)
Replies