topic Re: Store Command throwing general script error in QlikView

Store Command throwing general script error

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have created an app with a Store command. When I reload the script is works perfectly on the desktop but when I hand it off (to IT) to be loaded on the server this trips a general script error. Would anyone know how I can avoid this error?

Re: Store Command throwing general script error

m_woolf — Tue, 28 Jun 2016 17:22:22 GMT

You didn't give any details, so I'll guess.

Storing to a drive that isn't mapped on the server?

Re: Store Command throwing general script error

Clever_Anjos — Tue, 28 Jun 2016 17:25:11 GMT

Maybe you storing to a folder that you don´t have access.

Re: Store Command throwing general script error

avinashelite — Tue, 28 Jun 2016 17:25:19 GMT

check the path of the Store command and check whether your qlikview service account has complete access for that folder or location

Re: Store Command throwing general script error

santiago_respane — Tue, 28 Jun 2016 17:30:57 GMT

Hi Mr Jhon,

please elaborate more (add some screen shots, sample app, etc) in order to help you with your issue.

When you say "hand it off" you mean publish and reload it via QMC? Fails on the first load?

Will be waiting for your comments.

Kind regards,

Re: Store Command throwing general script error

krishnacbe — Tue, 28 Jun 2016 17:31:11 GMT

Share the Log to troubleshoot the issue

Re: Store Command throwing general script error

Anonymous — Tue, 28 Jun 2016 18:17:40 GMT

Attached is the log file.

Re: Store Command throwing general script error

Anil_Babu_Samineni — Tue, 28 Jun 2016 18:22:00 GMT

Check this time,

6/28/2016 11:36:33 AM

Showing some Access error with Uname and Pwd

- Anil

Re: Store Command throwing general script error

krishnacbe — Tue, 28 Jun 2016 19:04:54 GMT

The error shows in log is not with store statement. It is some DB username and password issue. Please try to connect to DB and after select statement you write Exit script and check. If it works then Store command will also works.

Re: Store Command throwing general script error

maxgro — Tue, 28 Jun 2016 19:41:46 GMT

Did you define the odbc data source (system data source) on the server and/or did you installed the driver for the db you're using? Also it seems (connect32) you're using a 32 bit connection.

6/28/2016 11:36:33 AM: 0008 ODBC CONNECT32*XUserId*XPassword*

6/28/2016 11:36:38 AM: Error: SQL##f - SqlState: IM002, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

6/28/2016 11:36:41 AM: General Script Error

6/28/2016 11:36:42 AM: Execution Failed

6/28/2016 11:36:46 AM: Execution finished.

Re: Store Command throwing general script error

avinashelite — Wed, 29 Jun 2016 05:21:08 GMT

Have you installed all the necessary drivers required to connect for the data source ?? if not as your server admin to still the same and create a ODBC connection in the server with the same name used in the document

Re: Store Command throwing general script error

Anonymous — Wed, 29 Jun 2016 19:17:15 GMT

STORE command is not the issue, sorry. I'm guessing now that the qv admin that's refreshing on the server does not have access to the database I'm connecting to (as stated before I can refresh on my desktop but when I hand if off to be published, the app fails). I'm wondering if this could cause the issue. I'm in the process of working through this still...