Forum Discussion
Power BI Informix connection error
After many unsucessful attempts, I contacted Microsoft support. After some remote access and data mining, the Power BI developer team found the problem:
After a few changes the error I was receiving changed from -1336 to -1040, wich meant EXCSAT_FAILURE, a protocol DRDA error from a Informix server.
Power BI uses DRDA protocol. I was using olsoctcp, I have been using the same port to all Microsoft products I currently use, so I had to change to a port that was configured with DRDA and it finally worked.
I'm replying to solve this topic and for anyone wich may have a similar problem.
Hi, have you seen this thread? http://community.powerbi.com/t5/Desktop/Connecting-to-Informix/m-p/53829/highlight/true#M21744
Hello arify, thanks for your reply.
Yes, I have seen this thread, but the error from it is SQLCODE=-1037 and my error is SQLCODE=-1366.
I checked everything from this thread but still can't connect.
Can you please send us a frown with traces?
For traces: Options > Diagnostics > Enable Tracing (Choose Verbose) > Open Traces folder, then reproduce the error. Trace files should appear in the traces folder. Please attach those traces in your frown email.
Thanks
Hi, arify.
I got the trace files but I don't know how to attach it to my frown email.
Should I post all the text here?
Also, there are 2 log files, wich one should I attach? Both?
This is the first one (Microsoft.Mashup.Container.NetFX40.6764.2016-08-11T12-08-37-342334).
Then there is another (PBIDesktop.6336.2016-08-11T12-08-18-998005). It is too big to post here as text.
SpoilerDataMashup.Trace Information: 24579 : {"Start":"2016-08-11T12:08:37.3450103Z","Action":"BackgroundThread/RollingTraceWriter/CleanupOldTraces","ProductVersion":"2.37.4464.461 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":6764,"Tid":4,"Duration":"00:00:00.0015948"}
DataMashup.Trace Information: 24579 : {"Start":"2016-08-11T12:08:37.7583268Z","Action":"SimpleDocumentEvaluator/BeginGetResult<IPreviewValueSource>/callback","ProductVersion":"2.37.4464.461 (PBIDesktop)","ActivityId":"7b89f82b-575c-4eda-b0fc-eb8d40b526d1","Process":"Microsoft.Mashup.Container.NetFX40","Pid":6764,"Tid":1,"Duration":"00:00:00.0011571"}
DataMashup.Trace Information: 24579 : {"Start":"2016-08-11T12:08:37.4603064Z","Action":"SimpleDocumentEvaluator/BeginGetResult<IValue>","ProductVersion":"2.37.4464.461 (PBIDesktop)","ActivityId":"7b89f82b-575c-4eda-b0fc-eb8d40b526d1","Process":"Microsoft.Mashup.Container.NetFX40","Pid":6764,"Tid":1,"Duration":"00:00:00.2991928"}
DataMashup.Trace Information: 24579 : {"Start":"2016-08-11T12:08:37.4447355Z","Action":"FirewallDocumentEvaluator/BeginGetResult","ProductVersion":"2.37.4464.461 (PBIDesktop)","ActivityId":"7b89f82b-575c-4eda-b0fc-eb8d40b526d1","Process":"Microsoft.Mashup.Container.NetFX40","Pid":6764,"Tid":1,"Duration":"00:00:00.3147719"}
DataMashup.Trace Information: 24579 : {"Start":"2016-08-11T12:08:43.0704875Z","Action":"Engine/IO/Db/Microsoft Informix Client/AuthorizationError","Exception":"Este host n\u00E3o \u00E9 conhecido SQLSTATE=08S01 SQLCODE=-1336","SqlCode":"-1336","ResourceExceptionKind":"None","ProductVersion":"2.37.4464.461 (PBIDesktop)","ActivityId":"7b89f82b-575c-4eda-b0fc-eb8d40b526d1","Process":"Microsoft.Mashup.Container.NetFX40","Pid":6764,"Tid":1,"Duration":"00:00:00.0010687"}
DataMashup.Trace Information: 24579 : {"Start":"2016-08-11T12:08:37.8978897Z","Action":"Engine/IO/Db/Microsoft Informix Client/RunWithRetry","ProductVersion":"2.37.4464.461 (PBIDesktop)","ActivityId":"7b89f82b-575c-4eda-b0fc-eb8d40b526d1","Process":"Microsoft.Mashup.Container.NetFX40","Pid":6764,"Tid":1,"Duration":"00:00:05.1908610"}
DataMashup.Trace Information: 24579 : {"Start":"2016-08-11T12:08:37.8859455Z","Action":"Engine/IO/Db/Microsoft Informix Client/RunWithRetry","ProductVersion":"2.37.4464.461 (PBIDesktop)","ActivityId":"7b89f82b-575c-4eda-b0fc-eb8d40b526d1","Process":"Microsoft.Mashup.Container.NetFX40","Pid":6764,"Tid":1,"Duration":"00:00:05.2041193"}If trying the recommendations in the other thread didn't work, I don't really have much to add.. Can you send a frown email if you're sure it's not a network issue?
There's a smiley on the top left corner or PBI Desktop, right next to it there's a little down-button, you can see the send a frown button in there. Please add the traces as well (if they're too big you can attach as zip)
Thanks
Hi arify,
I tried to import data directly from Pronto and was not succeessful. I tried both get data/from IBM informix and also ODBC connection. I got following errors. We also contacted our Pronto support and they confiigured the Port but still we get following errors. Could you please help? is there any email that I can send trace fiules so can have a look? I am not able to attach them here.
Thank you!