topic Re: Error in code in App Development

Error in code

Kirsten — Mon, 03 Aug 2020 11:57:20 GMT

I pull my data from a SQL database. The first code works fine until code nr 5

I get the following "error: -1= the error occurred here: ?" (see first attachment red marked where the error occurs, see second attachment for the error message) But in the code where it returns an error there is no -1 or ?

In all the subsequential codes the same error occurs

Re: Error in code

gp_oconnor — Mon, 03 Aug 2020 12:25:23 GMT

I think the error is related to the synthetic keys, which I think can be avoided by removing the "*," when populating the t_Link table or alternatively removing the fields EquipmentID, [System 6NC], CountryCode, [Part 12NC], SWO from all of the tables in the data model aside from the t_Link table.

Something else worth trying is temporarily removing the AutoNumberHash256 invocations.

Re: Error in code

Kirsten — Mon, 03 Aug 2020 16:23:58 GMT

@gp_oconnor Thanks it works. It is resolved by removing "*," The subsequential codes now always work, although I did not run them all yet. Since I changed something in the upload. What did I change and is there something I need to do after I uploaded all data to return it back to what it was?

Re: Error in code

gp_oconnor — Tue, 04 Aug 2020 07:35:39 GMT

@Kirsten, I'm not sure I understand your question correctly. Can you please supply some more information?

The synthetic keys were being generated because the dimension fields used for the compound keys were on the link table as well as on the fact tables. Removing the "*," would have fixed that and the compound keys would have been the only common fields between the fact tables and the link table. The data load should therefore complete without the strange error message you were experiencing previously.

Is the data model produced by the load script not giving you the expected results in the expressions / measures?

Re: Error in code

Kirsten — Tue, 04 Aug 2020 09:17:18 GMT

Hi @gp_oconnor The datamodel is giving me the expected results, and removing the "*," is resolving the issue. Just wanted to check if anything additional needs to be done. Thanks for the solution