Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dafnis14
Specialist
Specialist

SSO doesn't work when changing Excel to QVD

Hi,

We use SSO, where the users data are retrieved from Excel. Everything is running fine.

I have created a QVD file based on the Excel. But, when loading the users data from QVD, the SSO doesn't work, and the user is prompt

for the application user & password.

Here is the script:

Supps:
LOAD ACCESS,
USERID,
PASSWORD,
SERIAL,
NTNAME,
SUPPCODE
FROM
[..\..\Data\Suppliers\Final_Supp_QVD\TmpSupps.qvd]
(
qvd);

Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, SERIAL, NTNAME, SUPPCODE

  …..Deleted

    ];

Concatenate

LOAD

ACCESS

USERID,
SERIAL,
PASSWORD,
NTNAME,
SUPPCODE

Resident Supps;
 

Section Application;
 

STAR is *;
DROP Table Supps;


Does anyone have an idea why using the QVD disables the SSO?


Thsnks!

1 Solution

Accepted Solutions
dafnis14
Specialist
Specialist
Author

I found the solution here:

Section Access Reload from QVD fails

loaded the section access table in an unoptimized form:

FROM

[..\..\Data\Suppliers\Final_Supp_QVD\TmpSupps.qvd]

(qvd) Where 1=1;

View solution in original post

3 Replies
Clever_Anjos
Employee
Employee

You can´t access a table from a Application Section inside a Section Access, your should move your qvd load to inside "Section Access"

Supps:
LOAD ACCESS,
USERID,
PASSWORD,
SERIAL,
NTNAME,
SUPPCODE
FROM
[..\..\Data\Suppliers\Final_Supp_QVD\TmpSupps.qvd]
(
qvd);

Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, SERIAL, NTNAME, SUPPCODE

  …..Deleted

    ];

Concatenate

LOAD

ACCESS,

USERID,
SERIAL,
PASSWORD,
NTNAME,
SUPPCODE

Resident Supps; // This will not work because this table was created outside Section Access

Section Application;

STAR is *;
DROP Table Supps;

dafnis14
Specialist
Specialist
Author

Hi,

I had to do that after receiving general script error..

I can't understand why..

Thanks!

17/12/2015 18:42:26: 0065  Concatenate

17/12/2015 18:42:26: 0066  LOAD ACCESS,

17/12/2015 18:42:26: 0067       USERID,

17/12/2015 18:42:26: 0068       PASSWORD,

17/12/2015 18:42:26: 0069       SERIAL,

17/12/2015 18:42:26: 0070       NTNAME,

17/12/2015 18:42:26: 0071       SUPPCODE

17/12/2015 18:42:26: 0072  FROM

17/12/2015 18:42:26: 0073  [..\..\Data\Suppliers\Final_Supp_QVD\TmpSupps.qvd]

17/12/2015 18:42:26: 0074  (qvd)

17/12/2015 18:42:26:       6 fields found: ACCESS, USERID, PASSWORD, SERIAL, NTNAME, SUPPCODE, General Script Error

17/12/2015 18:42:26:       Execution Failed

17/12/2015 18:42:26:      Execution finished.

dafnis14
Specialist
Specialist
Author

I found the solution here:

Section Access Reload from QVD fails

loaded the section access table in an unoptimized form:

FROM

[..\..\Data\Suppliers\Final_Supp_QVD\TmpSupps.qvd]

(qvd) Where 1=1;