New version broke load scripts

michael_andrews — Sat, 16 Nov 2024 00:38:21 GMT

We have some load scripts that are failing when we upgraded to a new version (November 2020 13.102.11) on our testing environment. The exact load script works just fine on our production environment (April 2020 13.72.3).

I think I know what the problem is, but have no idea on why it's now happening or how to solve it. I included the relevant error log below and put the lines in red I think are the problem

20210210T080227.804-0700 0042 [candidate_temp_b26bf761-7728-b0b0-c9ac-556ed264]:
20210210T080227.804-0700 0043 LOAD
20210210T080227.804-0700 0044 [CandidateLastUpdatedDate],
20210210T080227.804-0700 0045 [AffiliationID],
20210210T080227.804-0700 0046 [CandidateAddressCountryCode],
20210210T080227.804-0700 0047 [CandidateCreatedDate],
20210210T080227.804-0700 0048 [CandidateAddressState],
20210210T080227.804-0700 0049 [CandidateID],
20210210T080227.804-0700 0050 [CandidateMeasure],
20210210T080227.804-0700 0051 [CandidateLastUpdatedTime],
20210210T080227.804-0700 0052 [CandidateFirstName],
20210210T080227.804-0700 0053 [CandidateLastName],
20210210T080227.804-0700 0054 [CandidateEmail],
20210210T080227.804-0700 0055 [CandidateCompanyName],
20210210T080227.804-0700 0056 [CandidateAddressCountryName],
20210210T080227.804-0700 0057 [CandidateAddressCountryRegion],
20210210T080227.804-0700 0058 [CandidateAffiliationCandidateID],
20210210T080227.804-0700 0059 [CandidateAffiliationEmail],
20210210T080227.805-0700 0060 [CandidateEmailLanguage],
20210210T080227.805-0700 0061 Date([CandidateBannedUntil] ) AS [CandidateBannedUntil],
20210210T080227.805-0700 0062 [CandidateWatchUntil],
20210210T080227.805-0700 0063 [CandidateLocFirstName],
20210210T080227.805-0700 0064 [CandidateLocLastName],
20210210T080227.805-0700 0065 [CandidateLocCompanyName],
20210210T080227.805-0700 0066 [CandidateAffiliationCompany],
20210210T080227.805-0700 0067 [CandidateAddressLine1],
20210210T080227.805-0700 0068 [CandidateAddressLine2],
20210210T080227.805-0700 0069 [CandidateAddressLine3],
20210210T080227.805-0700 0070 [CandidateAddressCity],
20210210T080227.805-0700 0071 [CandidateAddressPostalCode],
20210210T080227.805-0700 0072 APPLYMAP( '__countryCodeIsoThree2Polygon', UPPER([CandidateAddressCountryCode]), '-') AS [candidate.candidate.CandidateAddressCountryCode_GeoInfo],
20210210T080227.805-0700 0073 APPLYMAP( '__countryCodeIsoThree2Polygon', APPLYMAP( '__countryName2IsoThree', LOWER([CandidateAddressCountryName])), '-') AS [candidate.CandidateAddressCountryName_GeoInfo]
20210210T080227.805-0700 0074 RESIDENT [candidate]
20210210T080227.806-0700 Error: Table 'candidate' not found

It looks to me like qlik is now adding temp_someguid to our table name and so the load script can't reference it. How would we go about solving this?

Re: New version broke load scripts

NadiaB — Thu, 11 Feb 2021 21:39:45 GMT

Hi @michael_andrews

By any chance are you letting the Engine to name the table? Or are you explicitly naming the table?

Kind Regards.

topic New version broke load scripts in Management & Governance

New version broke load scripts

Re: New version broke load scripts