KB485938: “Column does not exist” error when using automatic fields with transaction grids in Dossier.

Principal Support Engineer • MicroStrategy

With the introduction of 2021 update 6, MicroStrategy Dossier supports the use of transaction grids. After configuring a grid to use transaction SQL, an error is received when using an automatic field.

Starting with the release of Strategy ONE (March 2024), dossiers are also known as dashboards.

Symptom

When using transaction services in a dossier an error is received when using an automatic field. The error can be found below:

“Failed transaction. The current transaction rolled back… Error in Process Method of component”

Cause

From the DSSErrors.log, a similar entry can be found:

Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [42S22:6820851: on SQLHANDLE] [Strategy][ODBC PostgreSQL Wire Protocol driver][PostgreSQL]ERROR: VERROR; column "xxx" does not exist(Position 79; File parse_relation.c; Line 3599; Routine errorMissingColumn; ) Connection String: DSN=Tutorial Postgres;UID=xxx;. SQL Statement: INSERT INTO public.lu_country (country_name,country_name_es) VALUES ('Test2', Administrator).

After enabling the SQL trace, an example transaction can be found below:

2023-01-25 11:35:21.983-05:00 [HOST:sup-w-004910][SERVER:CastorServer][PID:9692][THR:4076][Database Classes][SQL Trace][UID:54F3D26011D2896560009A8E67019608][SID:4916434CAA358FDACD2103125BA415B6][OID:65256E2B48EB281B563CBDBF4E285E78][StatementWrapper.cpp:526] Executing SQL. Connection ID: 6. SQL: INSERT INTO public.city_ctr_sls (cust_city_id, call_ctr_id) VALUES ( 'test',Administrator)

As seen above, the Administrator lacks quotes during the insert statement. The Administrator is the user login entry that is automatically generated. For comparison, the 'test' value has quotations which was not automatically generated.

Action

Manually add quotes in the transaction SQL. For example:

INSERT INTO  public.t_testing (    { description },    { request_id },    { requestor_name }  )VALUES  (    [Description@ID],    [Request Id@ID],    '[?User Login]'  )

Comment

0 comments

Details

Knowledge Article

Published:

March 3, 2023

Last Updated:

March 21, 2024

Cause

From the DSSErrors.log, a similar entry can be found:

Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [42S22:6820851: on SQLHANDLE] [Strategy][ODBC PostgreSQL Wire Protocol driver][PostgreSQL]ERROR: VERROR; column "xxx" does not exist(Position 79; File parse_relation.c; Line 3599; Routine errorMissingColumn; ) Connection String: DSN=Tutorial Postgres;UID=xxx;. SQL Statement: INSERT INTO public.lu_country (country_name,country_name_es) VALUES ('Test2', Administrator).

2023-01-25 11:35:21.983-05:00 [HOST:sup-w-004910][SERVER:CastorServer][PID:9692][THR:4076][Database Classes][SQL Trace][UID:54F3D26011D2896560009A8E67019608][SID:4916434CAA358FDACD2103125BA415B6][OID:65256E2B48EB281B563CBDBF4E285E78][StatementWrapper.cpp:526] Executing SQL. Connection ID: 6. SQL: INSERT INTO public.city_ctr_sls (cust_city_id, call_ctr_id) VALUES ( 'test',Administrator)