Problem with Google AD Manager (QWC) after update ... - Qlik Community

marpiotrowicz · ‎2022-12-11

Hello,

After upgrade to Nov 2022 - patch 2 we have problem with Qlik Web Connectors - Google Ad Manager connector.

We are using Report option.

Everything is fine in QWC - I can do save inputs and run table, got data preview etc. When I copy all the code to Qlik Sense after reload I've got error:

Error: Qvx file read error on line 32574, too many columns

Version of QWC didnt change. Was the same before update Qlik and everything was fine.

QWC Version: June-2022 (2.130.2.28334)

In the log of QWC i don see anything

<LogEntry version="1.0.3">
        <Id>8278f265-9073-4bab-adc7-db0a500349c2_17</Id>
        <Datetime>11-12-2022 14:23:14.95</Datetime>
        <Type>Info</Type>
        <Sender>GoogleAdManager.GoogleAdManagerConnector</Sender>
        <ServerMode>true</ServerMode>
        <Version>2.130.2.28334</Version>
        <Message>Starting table load GoogleAdManagerConnector.Report</Message>
        <Exception>NA</Exception>
        <ExceptionMessage>NA</ExceptionMessage>
        <AdditionalInfo>
            <RequestId>f4443456-9bb2-4f34-9444-956e83a2459a</RequestId>
            <ConnectorId>GoogleAdManagerConnector</ConnectorId>
            <Table>Report</Table>
        </AdditionalInfo>
    </LogEntry>
    <LogEntry version="1.0.3">
        <Id>8278f265-9073-4bab-adc7-db0a500349c2_20</Id>
        <Datetime>11-12-2022 14:24:16.397</Datetime>
        <Type>Trace</Type>
        <Sender>APIConnectorWeb.Nancy.Modules.WebAPIAuth</Sender>
        <ServerMode>true</ServerMode>
        <Version>2.130.2.28334</Version>
        <Message>AcceptedEulaVersion=2</Message>
        <Exception>NA</Exception>
        <ExceptionMessage>NA</ExceptionMessage>
        <AdditionalInfo>
            <UserIP>XXX</UserIP>
            <User>Admin (Default)</User>
        </AdditionalInfo>
    </LogEntry>
    <LogEntry version="1.0.3">
        <Id>8278f265-9073-4bab-adc7-db0a500349c2_43</Id>
        <Datetime>11-12-2022 14:28:32.068</Datetime>
        <Type>Info</Type>
        <Sender>GoogleAdManager.GoogleAdManagerConnector</Sender>
        <ServerMode>true</ServerMode>
        <Version>2.130.2.28334</Version>
        <Message>Finished table load GoogleAdManagerConnector.Report</Message>
        <Exception>NA</Exception>
        <ExceptionMessage>NA</ExceptionMessage>
        <AdditionalInfo>
            <RequestId>f4443456-9bb2-4f34-9444-956e83a2459a</RequestId>
            <ConnectorId>GoogleAdManagerConnector</ConnectorId>
            <Table>Report</Table>
            <TotalRequestTimeSeconds>317,1212781</TotalRequestTimeSeconds>
        </AdditionalInfo>
    </LogEntry>
    <LogEntry version="1.0.3">
        <Id>8278f265-9073-4bab-adc7-db0a500349c2_44</Id>
        <Datetime>11-12-2022 14:28:32.068</Datetime>
        <Type>Trace</Type>
        <Sender>APIConnectorWeb.Nancy.Modules.WebAPITableRequest.ConnectorDataHandler</Sender>
        <ServerMode>true</ServerMode>
        <Version>2.130.2.28334</Version>
        <Message>Processed load/request for user 'Admin (Default)', connector 'GoogleAdManagerConnector'</Message>
        <Exception>NA</Exception>
        <ExceptionMessage>NA</ExceptionMessage>
        <AdditionalInfo>
            <UserIP>XXX</UserIP>
            <RequestUrl>http://serverxxxx:5555/data?connectorID=GoogleAdManagerConnector&amp;table=Report&amp;encrypted_refresh_token=XXXXXX&amp;networkCode=xxxxx&amp;dateRangeType=CUSTOM_DATE&amp;dimensions=DATE%2cLINE_ITEM_ID%2cLINE_ITEM_NAME&amp;columns=TOTAL_LINE_ITEM_LEVEL_CLICKS%2cTOTAL_LINE_ITEM_LEVEL_IMPRESSIONS&amp;startDate=01-01-2020&amp;endDate=10-12-2022&amp;adUnitView=FLAT&amp;dimensionAttributes=LINE_ITEM_COST_TYPE%2cLINE_ITEM_COST_PER_UNIT&amp;appID=XXXXXX</RequestUrl>
            <loadAccessToken>XXXXXX</loadAccessToken>
            <userName>Admin (Default)</userName>
        </AdditionalInfo>
    </LogEntry>

jescorotero · ‎2023-01-20

We're facing the same issue. Did you find the solution?

marpiotrowicz · ‎2023-01-20

I've talked with qlik and they found a problem in qwc. New patch for qwc should be published on January 25.
Regards

Jay_Brown · ‎2023-01-23

Thanks @marpiotrowicz ! As mentioned, this will be in the Nov 2022 Patch, targeted to be released this week January 25th.

It should be shown with a fix ID in the release notes, most likely QB-17018.

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.

jescorotero · ‎2023-02-01

Hi @Jay_Brown,

Is there any delay with this new patch? Because I don't see any new release in the last week. Thanks.

marpiotrowicz · ‎2023-02-01

It looks like they published a new BETA version of Qlik Sense.

Problem with Google AD Manager (QWC) after update to Nov 2022

General Question