Unable to load document of identifier 'temp:query6' and type 'xtk:schema'

Avatar

Avatar

MeMonty

Avatar

MeMonty

MeMonty

10-03-2017

Hi,

I have built a workflow with a single query based on a single table. I have run the workflow and it shows some count (of records) in the result. When I used “Display the target” (in the context menu by right clicking on the Result arrow) to see the Result, I am getting the following error.

The edit from initialization has failed

Unable to load document of identifier 'temp:query6' and type 'xtk:schema'

Could you please advise.

Regards,

Mahantesh

View Entire Topic

Avatar

Avatar

MeMonty

Avatar

MeMonty

MeMonty

13-03-2017

Hi Vipul,

Thanks for your response. I did as you mentioned and the error I had mentioned has gone but it is giving a different error now.

Unable to read data from the base, the table has been purged or the current workflow configuration is no longer compatible with its structure.

Display errors during data loading...

When I clicked on this link, it is showing the detailed error message

PostgreSQL error: ERROR: relation "wkf1031459404_8_1" does not exist

LINE 1: ...(' || COALESCE(O1.sInternalName, '') || E')' FROM wkf1031459...

  ^

SQL statement 'SELECT   W0.iId, W0.iCampaignId, W0.sCampaignLabel, W0.iCampaignType, W0.dCampaignDuration, W0.iCampaignCancelStatus, W0.iCampaignState, W0.tsCampaignCreation, W0.tsCampaignLastModified, W0.tsCampaignStart, W0.tsCampaignEnd, COALESCE(O1.sLabel, '') || E' (' || COALESCE(O1.sInternalName, '') || E')' FROM wkf1031459404_8_1 W0 JOIN NmsOperation O1 ON (O1.iOperationId = W0.iId) LIMIT 200' could not be executed.

  Unable to complete operation in current state.

Could you please advise.

Regards,

Mahantesh