Error script during the creation of the QVD

[ab92]

Hi everyone !

Please see below my error :

i create this variable  :

SET vQVD_X3ERP='..\Entrepot\X3ERP\';

Please could you help me about this problem ?

[techvarun]

https://www.techonthenet.com/oracle/errors/ora00911.php

https://community.qlik.com/thread/248959

[tresesco]

Try removing the single quotes around variable like:

SQL SELECT *
FROM QLICKVIEW. $(vNOM_TABLE);

[ab92]

Hi Tresesco,

Many thanks for your help but unfortunatly is not working :

Do you have an other idea ?

[tresesco]

If you try without quotes what is the outcome?

[ab92]

Please see below the new script error : it's like the same no ?

[Miguel_Angel_Baeyens]

Without quotes, the driver returns that the table does not exist, while with quotes it says that the character is not valid. Are those the right single quotes to be used with that driver? I have seen in PostgreSQL databases the use of the acute ` and in most of other databases either single quotes ( ' chr 39) or double (" chr - 34)

[ab92]

Hi Miguel,

Thanks for your opinion but do you have an advice for this problem ?

[Miguel_Angel_Baeyens]

Was not an opinion, I just don't know which driver is it using and which quotes are the right ones. At a first glance, if you are not using PostgreSQL databases, I'd say the ` character for the table is not being accepted by the driver (for example, see ORA-00911: invalid character - TekStream).

However, without further details I cannot say.

[ab92]

Hi Varun, please could you develop your opinion ?

i read your documents I try without to reload with this function

SQL SELECT *
FROM QLICKVIEW

Is not working. same error.

Do you have an advice ?

Many thanks.