topic Re: error ;SqlState: S1000, ErrorCode: 936 in QlikView

error ;SqlState: S1000, ErrorCode: 936

diwaskarki — Sat, 16 Nov 2024 02:42:18 GMT

Hello guys,

I just changed my database connection from db2 to sql.

I had this query before :

SPT_VIOLATION:
LOAD TARGET_NAME,
VIOLATION_SUMMARY,
STATUS,
SUMMARY_STATUS,
NAME;
SQL SELECT entity.target_name, item.violation_summary, action.status, item.summary_status, group.name from identityiq.spt_certification_item item inner join identityiq.spt_certification_action action on item.action = action.id
inner join identityiq.spt_certification_entity entity on item.certification_entity_id = entity.id
inner join identityiq.spt_certification cert on entity.certification_id = cert.id
inner join identityiq.spt_certification_group group on cert.certification_definition_id = group.certification_definition where item.type='PolicyViolation' and entity.target_name='A00A' with ur ;

store SPT_VIOLATION into ..\..\QVD\SPT_VIOLATION.qvd;

for my sql connection, I removed with ur, which is only specific to db2.

But I am receiving the above error. I cant seem to find what I am doing wrong. Any ideas would be greatly appreciated.

Re: error ;SqlState: S1000, ErrorCode: 936

Claudiu_Anghelescu — Tue, 20 Aug 2019 06:42:27 GMT

But if you run the SQL script into the Oracle database client, the script runs properly?

Re: error ;SqlState: S1000, ErrorCode: 936

Brett_Bleess — Tue, 03 Sep 2019 14:00:13 GMT

Diwas, so I have a clarification question here, is the platform still IBM, or is the SQL connection to a new source such as Oracle or Microsoft etc...? When I did some Google searching, it appeared IBM may have something related here, so I just wanted to try to get further clarification on exactly what all has changed here?

Just a side note, these issues are generally related to the Connector/Driver being used for the connection to the backend source, not really a QlikView message, we are simply reporting what the Connector/Driver gave us, so you will likely find better information to troubleshoot on the Connector/Driver vendor Community in this case...

Regards,
Brett

Re: error ;SqlState: S1000, ErrorCode: 936

diwaskarki — Tue, 03 Sep 2019 14:02:26 GMT

I have figured out what the issue is. I have renamed a table as "group". In oracle, it is apparently a keyword so I cant rename a table to group. I changed the name to something else and it worked.

Re: error ;SqlState: S1000, ErrorCode: 936

diwaskarki — Mon, 28 Oct 2019 18:28:45 GMT

it is an Oracle db.