topic Re: getting error when reload in Script builder SAPReloadDD.qvw in QlikView

getting error when reload in Script builder SAPReloadDD.qvw

vipin_mishra479 — Wed, 21 Sep 2016 10:15:22 GMT

Hi All,

i trying to fetch the data from SAP BW and i have a script builder and i am trying to load ReloadDD.qvw file and i am getting error

ODBC connection failed

SQL SELECT * From DD02L;

Please help.

Re: getting error when reload in Script builder SAPReloadDD.qvw

adamdavi3s — Wed, 21 Sep 2016 10:28:51 GMT

Not sure we can really help you with this one, other than to say check the ODBC is set up on the machine you are loading it on and the user has the correct access etc.

Check if the ODBC is 32/64 bit and make sure Qlik is set accordingly

You could also try OLEDB instead

Has this just started failing or has it never worked?

Re: getting error when reload in Script builder SAPReloadDD.qvw

agomes1971 — Wed, 21 Sep 2016 10:37:45 GMT

Hi,

please see this

ODBC Connection failed

SAP connection TO QV

HTH

André Gomes

Re: getting error when reload in Script builder SAPReloadDD.qvw

vipin_mishra479 — Wed, 21 Sep 2016 10:53:01 GMT

Hi Thanks for a quick reply

this is my SAP connection string

CUSTOM CONNECT TO "Provider=QvSAPConnector.dll;ASHOST=dtwdisap.dat.datwyler.biz;SYSNR=30;CLIENT=100;KeepCasing=1;NullDate=1;XUserId=aKEHXIRJJaSMVEVIXSSB;XPassword=PZRMNCFMUbXCFLFGSZMCA;";

and i have a question when we try to fetch the data from SAP side So why i get ODBC connection error

Re: getting error when reload in Script builder SAPReloadDD.qvw

agomes1971 — Wed, 21 Sep 2016 11:34:24 GMT

Hi,

have you saw this

https://help.qlik.com/en-US/connectors/Subsystems/SAP_Connectors_Help/Content/6.1/QV-connection/SAP-SQL-connection.htm

HTH

André Gomes

Re: getting error when reload in Script builder SAPReloadDD.qvw

vipin_mishra479 — Wed, 21 Sep 2016 11:45:34 GMT

Hi Andre,

thanks for the reply i have checked i don't have advance option but i am worried why i am getting this error.

Re: getting error when reload in Script builder SAPReloadDD.qvw

Peter_Cammaert — Wed, 21 Sep 2016 12:22:05 GMT

Indeed, getting QDBC errors when connecting to SAP using the SAP Connector is a bit strange. Can you post the entire script log? Open ReLoadSAPDD.qvw, select Settings->Document Properties->General and enable option "Generate Log File". Then try to reload.

Re: getting error when reload in Script builder SAPReloadDD.qvw

Peter_Cammaert — Wed, 21 Sep 2016 12:23:15 GMT

You did properly install and license the SAP Connector before running the reload scirpt, didn't you?

Re: getting error when reload in Script builder SAPReloadDD.qvw

vipin_mishra479 — Wed, 21 Sep 2016 12:25:37 GMT

now its working fine I don't know why this will happen,,,Thanks guy thanks for your response

Re: getting error when reload in Script builder SAPReloadDD.qvw

Anil_Babu_Samineni — Wed, 21 Sep 2016 12:26:56 GMT

Vipin, For SAP Connector you need to create one DNS

Re: getting error when reload in Script builder SAPReloadDD.qvw

Anil_Babu_Samineni — Wed, 21 Sep 2016 12:27:37 GMT

Haha, Sometimes it happen. NW Please close this thread with the Flag of Correct Answer