Skip to content

Instantly share code, notes, and snippets.

@danielmklein

danielmklein/gist:4cb39aa39ba2e5363410dff600ab3ced

Created June 4, 2018 13:33
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save danielmklein/4cb39aa39ba2e5363410dff600ab3ced to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save danielmklein/4cb39aa39ba2e5363410dff600ab3ced to your computer and use it in GitHub Desktop.
Download ZIP
Redshift PowerBI Folding Error
Raw
gistfile1.txt
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0288274Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_ODBC_VER","Value":"03.80","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000118"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0277019Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"6768","Attempt":"0","MaxAttempt":"3","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0012057"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0276873Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0012285"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0290147Z","Action":"Engine/IO/Odbc/Connection/Open","HostProcessId":"6768","CurrentCatalog":null,"ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000050"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0290293Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_NAME","Value":"Microsoft Amazon Redshift ODBC Driver","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000296"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0290646Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_VER","Value":"1.4.1.1002","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000060"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0290755Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DBMS_NAME","Value":"Redshift","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000052"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0290847Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DBMS_VER","Value":"8.0.2","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000058"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0290266Z","Action":"Engine/IO/Odbc/Connection/Info","HostProcessId":"6768","DriverName":"Microsoft Amazon Redshift ODBC Driver","DriverVersion":"1.4.1.1002","DBMSName":"Redshift","DBMSVersion":"8.0.2","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000714"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0291348Z","Action":"Engine/IO/Odbc/Command/GetTables","HostProcessId":"6768","CatalogName":"%","SchemaName":"","TableName":"","TableType":"","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000288"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0290013Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"6768","Attempt":"0","MaxAttempt":"3","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0001769"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0289938Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0001897"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0303390Z","Action":"Engine/IO/Odbc/Connection/Open","HostProcessId":"6768","CurrentCatalog":null,"ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000063"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0304107Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_NAME","Value":"Microsoft Amazon Redshift ODBC Driver","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000349"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0304533Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_VER","Value":"1.4.1.1002","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000071"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0304650Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DBMS_NAME","Value":"Redshift","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000057"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0304757Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DBMS_VER","Value":"8.0.2","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000052"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0304064Z","Action":"Engine/IO/Odbc/Connection/Info","HostProcessId":"6768","DriverName":"Microsoft Amazon Redshift ODBC Driver","DriverVersion":"1.4.1.1002","DBMSName":"Redshift","DBMSVersion":"8.0.2","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000833"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0304958Z","Action":"Engine/IO/Odbc/Command/GetTables","HostProcessId":"6768","CatalogName":"%","SchemaName":null,"TableName":null,"TableType":"TABLE,VIEW","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000249"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0303194Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"6768","Attempt":"0","MaxAttempt":"3","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0002811"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0303035Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0003063"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0308320Z","Action":"Engine/IO/Odbc/Connection/Open","HostProcessId":"6768","CurrentCatalog":null,"ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000052"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0308533Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_NAME","Value":"Microsoft Amazon Redshift ODBC Driver","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000288"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0308896Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_VER","Value":"1.4.1.1002","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000067"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0309029Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DBMS_NAME","Value":"Redshift","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000079"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0309167Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DBMS_VER","Value":"8.0.2","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000084"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0308488Z","Action":"Engine/IO/Odbc/Connection/Info","HostProcessId":"6768","DriverName":"Microsoft Amazon Redshift ODBC Driver","DriverVersion":"1.4.1.1002","DBMSName":"Redshift","DBMSVersion":"8.0.2","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000875"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0309471Z","Action":"Engine/IO/Odbc/Command/GetColumns","HostProcessId":"6768","CatalogName":"nmdw","SchemaName":"public","TableName":"companymap","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000303"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0308175Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"6768","Attempt":"0","MaxAttempt":"3","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0002137"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0308073Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0002322"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0311064Z","Action":"Engine/IO/Odbc/Connection/Open","HostProcessId":"6768","CurrentCatalog":null,"ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000041"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0311201Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_NAME","Value":"Microsoft Amazon Redshift ODBC Driver","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000157"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0311421Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_VER","Value":"1.4.1.1002","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000059"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0311521Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DBMS_NAME","Value":"Redshift","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000060"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0311620Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DBMS_VER","Value":"8.0.2","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000052"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0311167Z","Action":"Engine/IO/Odbc/Connection/Info","HostProcessId":"6768","DriverName":"Microsoft Amazon Redshift ODBC Driver","DriverVersion":"1.4.1.1002","DBMSName":"Redshift","DBMSVersion":"8.0.2","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000580"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0310928Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"6768","Attempt":"0","MaxAttempt":"3","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0002542"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0310874Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0002962"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0314219Z","Action":"Engine/IO/Odbc/Connection/Open","HostProcessId":"6768","CurrentCatalog":null,"ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000039"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0314346Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_NAME","Value":"Microsoft Amazon Redshift ODBC Driver","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000213"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0314942Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_VER","Value":"1.4.1.1002","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000077"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0315063Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DBMS_NAME","Value":"Redshift","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000059"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0315159Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DBMS_VER","Value":"8.0.2","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000049"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0314319Z","Action":"Engine/IO/Odbc/Connection/Info","HostProcessId":"6768","DriverName":"Microsoft Amazon Redshift ODBC Driver","DriverVersion":"1.4.1.1002","DBMSName":"Redshift","DBMSVersion":"8.0.2","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000962"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0315342Z","Action":"Engine/IO/Odbc/Connection/GetFunctions","HostProcessId":"6768","FunctionId":"SQL_API_SQLPRIMARYKEYS","Value":"True","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000138"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0315573Z","Action":"Engine/IO/Odbc/Command/GetPrimaryKeys","HostProcessId":"6768","CatalogName":"nmdw","SchemaName":"public","TableName":"companymap","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000203"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0314102Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"6768","Attempt":"0","MaxAttempt":"3","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0001773"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0314039Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0001886"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0316287Z","Action":"Engine/IO/Odbc/Connection/Open","HostProcessId":"6768","CurrentCatalog":null,"ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000039"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0316412Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_NAME","Value":"Microsoft Amazon Redshift ODBC Driver","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000122"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0316593Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_VER","Value":"1.4.1.1002","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000055"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0316866Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DBMS_NAME","Value":"Redshift","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000077"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0316986Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DBMS_VER","Value":"8.0.2","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000050"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0316387Z","Action":"Engine/IO/Odbc/Connection/Info","HostProcessId":"6768","DriverName":"Microsoft Amazon Redshift ODBC Driver","DriverVersion":"1.4.1.1002","DBMSName":"Redshift","DBMSVersion":"8.0.2","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000720"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0317157Z","Action":"Engine/IO/Odbc/Connection/GetFunctions","HostProcessId":"6768","FunctionId":"SQL_API_SQLFOREIGNKEYS","Value":"True","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000127"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0317339Z","Action":"Engine/IO/Odbc/Command/GetForeignKeys","HostProcessId":"6768","PKCatalogName":null,"PKSchemaName":null,"PKTableName":null,"FKCatalogName":"nmdw","FKSchemaName":"public","FKTableName":"companymap","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000164"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0316202Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"6768","Attempt":"0","MaxAttempt":"3","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0001385"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0316167Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0001491"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0317882Z","Action":"Engine/IO/Odbc/Connection/Open","HostProcessId":"6768","CurrentCatalog":null,"ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000063"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0318048Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_NAME","Value":"Microsoft Amazon Redshift ODBC Driver","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000140"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0318240Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_VER","Value":"1.4.1.1002","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000053"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0319020Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DBMS_NAME","Value":"Redshift","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000093"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0319168Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DBMS_VER","Value":"8.0.2","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000058"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0318019Z","Action":"Engine/IO/Odbc/Connection/Info","HostProcessId":"6768","DriverName":"Microsoft Amazon Redshift ODBC Driver","DriverVersion":"1.4.1.1002","DBMSName":"Redshift","DBMSVersion":"8.0.2","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0001275"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0319353Z","Action":"Engine/IO/Odbc/Connection/GetFunctions","HostProcessId":"6768","FunctionId":"SQL_API_SQLFOREIGNKEYS","Value":"True","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000130"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0319535Z","Action":"Engine/IO/Odbc/Command/GetForeignKeys","HostProcessId":"6768","PKCatalogName":"nmdw","PKSchemaName":"public","PKTableName":"companymap","FKCatalogName":null,"FKSchemaName":null,"FKTableName":null,"ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000167"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0317774Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"6768","Attempt":"0","MaxAttempt":"3","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0002015"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0317723Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0002115"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:34.9366017Z","Action":"SqlExpressionTranslator/Translate","HostProcessId":"6768","IsRecognized":"True","Result":"(environment) => Table.RenameColumns(let\r\n t4229 = let\r\n t4226 = let\r\n t4218 = Table.RenameColumns(Table.PrefixColumns(environment[dailycensus], \"dailycensus\"), {{\"dailycensus.companyid\", \"t3.companyid\"}, {\"dailycensus.companyname\", \"t3.companyname\"}, {\"dailycensus.agreementtype\", \"t3.agreementtype\"}, {\"dailycensus.contracttype\", \"t3.contracttype\"}, {\"dailycensus.censusdate\", \"t3.censusdate\"}, {\"dailycensus.censuscount\", \"t3.censuscount\"}, {\"dailycensus.isnewimplementation\", \"t3.isnewimplementation\"}, {\"dailycensus.isactive\", \"t3.isactive\"}, {\"dailycensus.companypreviousinvoicedate\", \"t3.companypreviousinvoicedate\"}}),\r\n t4219 = Table.RenameColumns(Table.PrefixColumns(environment[dimdate], \"dimdate\"), {{\"dimdate.id\", \"t2.id\"}, {\"dimdate.date\", \"t2.date\"}, {\"dimdate.day\", \"t2.day\"}, {\"dimdate.daysuffix\", \"t2.daysuffix\"}, {\"dimdate.weekday\", \"t2.weekday\"}, {\"dimdate.weekdayname\", \"t2.weekdayname\"}, {\"dimdate.isweekend\", \"t2.isweekend\"}, {\"dimdate.isholiday\", \"t2.isholiday\"}, {\"dimdate.holidaytext\", \"t2.holidaytext\"}, {\"dimdate.dowinmonth\", \"t2.dowinmonth\"}, {\"dimdate.dayofyear\", \"t2.dayofyear\"}, {\"dimdate.weekofmonth\", \"t2.weekofmonth\"}, {\"dimdate.weekofyear\", \"t2.weekofyear\"}, {\"dimdate.isoweekofyear\", \"t2.isoweekofyear\"}, {\"dimdate.month\", \"t2.month\"}, {\"dimdate.monthname\", \"t2.monthname\"}, {\"dimdate.quarter\", \"t2.quarter\"}, {\"dimdate.quartername\", \"t2.quartername\"}, {\"dimdate.year\", \"t2.year\"}, {\"dimdate.mmyyyy\", \"t2.mmyyyy\"}, {\"dimdate.monthyear\", \"t2.monthyear\"}, {\"dimdate.firstdayofmonth\", \"t2.firstdayofmonth\"}, {\"dimdate.lastdayofmonth\", \"t2.lastdayofmonth\"}, {\"dimdate.firstdayofquarter\", \"t2.firstdayofquarter\"}, {\"dimdate.lastdayofquarter\", \"t2.lastdayofquarter\"}, {\"dimdate.firstdayofyear\", \"t2.firstdayofyear\"}, {\"dimdate.lastdayofyear\", \"t2.lastdayofyear\"}, {\"dimdate.firstdayofnextmonth\", \"t2.firstdayofnextmonth\"}, {\"dimdate.firstdayofnextyear\", \"t2.firstdayofnextyear\"}, {\"dimdate.yyyymm\", \"t2.yyyymm\"}, {\"dimdate.yyyyquarter\", \"t2.yyyyquarter\"}}),\r\n t4220 = Table.Join(t4218, {\"t3.censusdate\"}, t4219, {\"t2.id\"}, JoinKind.LeftOuter, null, {Value.NullableEquals})\r\n in\r\n t4220,\r\n t4227 = Table.RenameColumns(Table.PrefixColumns(environment[CompanyMap], \"CompanyMap\"), {{\"CompanyMap.companynpi\", \"t5.companynpi\"}, {\"CompanyMap.companyid\", \"t5.companyid\"}, {\"CompanyMap.companyname\", \"t5.companyname\"}, {\"CompanyMap.companytype\", \"t5.companytype\"}, {\"CompanyMap.companyaddress1\", \"t5.companyaddress1\"}, {\"CompanyMap.companyaddress2\", \"t5.companyaddress2\"}, {\"CompanyMap.companycity\", \"t5.companycity\"}, {\"CompanyMap.companystate\", \"t5.companystate\"}, {\"CompanyMap.companypostalcode\", \"t5.companypostalcode\"}, {\"CompanyMap.companyphone\", \"t5.companyphone\"}, {\"CompanyMap.mailingaddress1\", \"t5.mailingaddress1\"}, {\"CompanyMap.mailingaddress2\", \"t5.mailingaddress2\"}, {\"CompanyMap.mailingcity\", \"t5.mailingcity\"}, {\"CompanyMap.mailingstate\", \"t5.mailingstate\"}, {\"CompanyMap.mailingpostalcode\", \"t5.mailingpostalcode\"}, {\"CompanyMap.timezone\", \"t5.timezone\"}, {\"CompanyMap.createddate\", \"t5.createddate\"}, {\"CompanyMap.modifieddate\", \"t5.modifieddate\"}, {\"CompanyMap.termdays\", \"t5.termdays\"}, {\"CompanyMap.parentid\", \"t5.parentid\"}, {\"CompanyMap.corporateparentid\", \"t5.corporateparentid\"}, {\"CompanyMap.corporateparentname\", \"t5.corporateparentname\"}, {\"CompanyMap.hierarchy\", \"t5.hierarchy\"}, {\"CompanyMap.hierarchylevel\", \"t5.hierarchylevel\"}, {\"CompanyMap.targetcppd\", \"t5.targetcppd\"}, {\"CompanyMap.targetdmepercent\", \"t5.targetdmepercent\"}, {\"CompanyMap.targetoofpercent\", \"t5.targetoofpercent\"}, {\"CompanyMap.targetsystemusagepercent\", \"t5.targetsystemusagepercent\"}, {\"CompanyMap.prehlspend\", \"t5.prehlspend\"}, {\"CompanyMap.prehltpd\", \"t5.prehltpd\"}, {\"CompanyMap.prehlcppd\", \"t5.prehlcppd\"}, {\"CompanyMap.prehldmeutilization\", \"t5.prehldmeutilization\"}, {\"CompanyMap.prehltotaldmedays\", \"t5.prehltotaldmedays\"}, {\"CompanyMap.istest\", \"t5.istest\"}, {\"CompanyMap.latitude\", \"t5.latitude\"}, {\"CompanyMap.longitude\", \"t5.longitude\"}, {\"CompanyMap.agreementtype\", \"t5.agreementtype\"}}),\r\n","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0961516"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:34.9349711Z","Action":"SimpleDocumentEvaluator/GetResult/Evaluate","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.1012699"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0396082Z","Action":"Engine/IO/Odbc/Connection/Open","HostProcessId":"6768","CurrentCatalog":null,"ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000072"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0396638Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_NAME","Value":"Microsoft Amazon Redshift ODBC Driver","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0001450"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0398832Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_VER","Value":"1.4.1.1002","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000309"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0399362Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DBMS_NAME","Value":"Redshift","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000526"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0400073Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DBMS_VER","Value":"8.0.2","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000253"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0396583Z","Action":"Engine/IO/Odbc/Connection/Info","HostProcessId":"6768","DriverName":"Microsoft Amazon Redshift ODBC Driver","DriverVersion":"1.4.1.1002","DBMSName":"Redshift","DBMSVersion":"8.0.2","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0003928"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0462146Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":12,"Duration":"00:00:00.0022546"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0395732Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"6768","Attempt":"0","MaxAttempt":"3","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0423428"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0395565Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0424249"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0821347Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"6768","Attempt":"0","MaxAttempt":"0","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0004120"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0821151Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0004914"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0829975Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"6768","Attempt":"0","MaxAttempt":"0","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000997"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0829954Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0001336"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0829916Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"6768","Attempt":"0","MaxAttempt":"0","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0001489"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0829773Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0001685"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0831841Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"6768","Attempt":"0","MaxAttempt":"0","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000279"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0831821Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000588"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0831791Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"6768","Attempt":"0","MaxAttempt":"0","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000701"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0831727Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000815"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0833702Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"6768","Attempt":"0","MaxAttempt":"0","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":8,"Duration":"00:00:00.0000058"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0833557Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":8,"Duration":"00:00:00.0000624"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0834345Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"6768","Attempt":"0","MaxAttempt":"0","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":8,"Duration":"00:00:00.0000038"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0834302Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":8,"Duration":"00:00:00.0000319"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0835136Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"6768","Attempt":"0","MaxAttempt":"0","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":8,"Duration":"00:00:00.0000189"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0835082Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":8,"Duration":"00:00:00.0000347"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0835661Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"6768","Attempt":"0","MaxAttempt":"0","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":8,"Duration":"00:00:00.0000037"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0835613Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":8,"Duration":"00:00:00.0000289"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0836030Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"6768","Attempt":"0","MaxAttempt":"0","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":8,"Duration":"00:00:00.0000191"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0835992Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":8,"Duration":"00:00:00.0000337"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0836486Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"6768","Attempt":"0","MaxAttempt":"0","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":8,"Duration":"00:00:00.0000179"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0836444Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":8,"Duration":"00:00:00.0000734"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0837658Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"6768","Attempt":"0","MaxAttempt":"0","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":8,"Duration":"00:00:00.0000057"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0837570Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":8,"Duration":"00:00:00.0002064"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0839892Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"6768","Attempt":"0","MaxAttempt":"0","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":8,"Duration":"00:00:00.0000248"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0839812Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":8,"Duration":"00:00:00.0000962"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0840953Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"6768","Attempt":"0","MaxAttempt":"0","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":8,"Duration":"00:00:00.0000272"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0840882Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":8,"Duration":"00:00:00.0000485"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0841709Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"6768","Attempt":"0","MaxAttempt":"0","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":8,"Duration":"00:00:00.0000058"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0841642Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":8,"Duration":"00:00:00.0000406"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0400605Z","Action":"Engine/IO/Odbc/Command/ExecuteDirect","HostProcessId":"6768","CommandText":"select top 1000001\r\n \"id\",\r\n \"censuscount\",\r\n \"companypreviousinvoicedate\",\r\n \"C1\",\r\n max(\"censusdate\") as \"C2\"\r\nfrom \r\n(\r\n select \"censusdate\",\r\n \"censuscount\",\r\n \"companypreviousinvoicedate\",\r\n \"id\",\r\n \"C1\"\r\n from \r\n (\r\n select \"OTBL\".\"companyid\",\r\n \"OTBL\".\"companyname\",\r\n \"OTBL\".\"agreementtype\",\r\n \"OTBL\".\"contracttype\",\r\n \"OTBL\".\"censusdate\",\r\n \"OTBL\".\"censuscount\",\r\n \"OTBL\".\"isnewimplementation\",\r\n \"OTBL\".\"isactive\",\r\n \"OTBL\".\"companypreviousinvoicedate\",\r\n \"OTBL\".\"id\",\r\n \"OTBL\".\"date\",\r\n \"OTBL\".\"day\",\r\n \"OTBL\".\"daysuffix\",\r\n \"OTBL\".\"weekday\",\r\n \"OTBL\".\"weekdayname\",\r\n \"OTBL\".\"isweekend\",\r\n \"OTBL\".\"isholiday\",\r\n \"OTBL\".\"holidaytext\",\r\n \"OTBL\".\"dowinmonth\",\r\n \"OTBL\".\"dayofyear\",\r\n \"OTBL\".\"weekofmonth\",\r\n \"OTBL\".\"weekofyear\",\r\n \"OTBL\".\"isoweekofyear\",\r\n \"OTBL\".\"month\",\r\n \"OTBL\".\"monthname\",\r\n \"OTBL\".\"quarter\",\r\n \"OTBL\".\"quartername\",\r\n \"OTBL\".\"year\",\r\n \"OTBL\".\"mmyyyy\",\r\n \"OTBL\".\"monthyear\",\r\n \"OTBL\".\"firstdayofmonth\",\r\n \"OTBL\".\"lastdayofmonth\",\r\n \"OTBL\".\"firstdayofquarter\",\r\n \"OTBL\".\"lastdayofquarter\",\r\n \"OTBL\".\"firstdayofyear\",\r\n \"OTBL\".\"lastdayofyear\",\r\n \"OTBL\".\"firstdayofnextmonth\",\r\n \"OTBL\".\"firstdayofnextyear\",\r\n \"OTBL\".\"yyyymm\",\r\n \"OTBL\".\"yyyyquarter\",\r\n \"ITBL\".\"companynpi\",\r\n \"ITBL\".\"companyid\" as \"C1\",\r\n \"ITBL\".\"companyname\" as \"C2\",\r\n \"ITBL\".\"companytype\",\r\n \"ITBL\".\"companyaddress1\",\r\n \"ITBL\".\"companyaddress2\",\r\n \"ITBL\".\"companycity\",\r\n \"ITBL\".\"companystate\",\r\n \"ITBL\".\"companypostalcode\",\r\n \"ITBL\".\"companyphone\",\r\n \"ITBL\".\"mailingaddress1\",\r\n \"ITBL\".\"mailingaddress2\",\r\n \"ITBL\".\"mailingcity\",\r\n \"ITBL\".\"mailingstate\",\r\n \"ITBL\".\"mailingpostalcode\",\r\n \"ITBL\".\"timezone\",\r\n \"ITBL\".\"createddate\",\r\n \"ITBL\".\"modifieddate\",\r\n \"ITBL\".\"termdays\",\r\n \"ITBL\".\"parentid\",\r\n \"ITBL\".\"corporateparentid\",\r\n \"ITBL\".\"corporateparentname\",\r\n \"ITBL\".\"hierarchy\",\r\n \"ITBL\".\"hierarchylevel\",\r\n \"ITBL\".\"targetcppd\",\r\n \"ITBL\".\"targetdmepercent\",\r\n \"ITBL\".\"targetoofpercent\",\r\n \"ITBL\".\"targetsystemusagepercent\",\r\n \"ITBL\".\"prehlspend\",\r\n \"ITBL\".\"prehltpd\",\r\n \"ITBL\".\"prehlcppd\",\r\n \"ITBL\".\"prehldmeutilization\",\r\n \"ITBL\".\"prehltotaldmedays\",\r\n \"ITBL\".\"istest\",\r\n \"ITBL\".\"latitude\",\r\n \"ITBL\".\"longitude\",\r\n \"ITBL\".\"agreementtype\" as \"C3\"\r\n from \r\n (\r\n select \"OTBL\".\"companyid\",\r\n \"OTBL\".\"companyname\",\r\n \"OTBL\".\"agreementtype\",\r\n \"OTBL\".\"contracttype\",\r\n \"OTBL\".\"censusdate\",\r\n \"OTBL\".\"censuscount\",\r\n \"OTBL\".\"isnewimplementation\",\r\n \"OTBL\".\"isactive\",\r\n \"OTBL\".\"companypreviousinvoicedate\",\r\n \"ITBL\".\"id\",\r\n \"ITBL\".\"date\",\r\n \"ITBL\".\"day\",\r\n \"ITBL\".\"daysuffix\",\r\n \"ITBL\".\"weekday\",\r\n \"ITBL\".\"weekdayname\",\r\n \"ITBL\".\"isweekend\",\r\n \"ITBL\".\"isholiday\",\r\n \"ITBL\".\"holidaytext\",\r\n \"ITBL\".\"dowinmonth\",\r\n \"ITBL\".\"dayofyear\",\r\n \"ITBL\".\"weekofmonth\",\r\n \"ITBL\".\"weekofyear\",\r\n \"ITBL\".\"isoweekofyear\",\r\n \"ITBL\".\"month\",\r\n \"ITBL\".\"monthname\",\r\n \"ITBL\".\"quarter\",\r\n \"ITBL\".\"quartername\",\r","ParameterCount":"0","Skip":"0","Take":"Infinite","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0424482"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:34.9222385Z","Action":"SimpleDocumentEvaluator/GetResult<IDataReaderSource>","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.1613756"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:34.9212636Z","Action":"FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Engine.Interface.IDataReaderSource>","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.1150803"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0363727Z","Action":"RemotePageReader/RunStub","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0488435"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:34.9211516Z","Action":"RemoteDocumentEvaluator/Service/OnBeginGetResult","HostProcessId":"6768","evaluationID":"3552","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.1641198"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:35.0936206Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":12,"Duration":"00:00:00.0001523"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:39.7622403Z","Action":"DependencyCompiler/Dispose","HostProcessId":"6768","AmazonRedshift":"True","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000294"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:39.7623454Z","Action":"MemoryCache/CacheStats/Size","HostProcessId":"6768","entryCount":"21","totalSize":"40199","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000064"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:39.7623772Z","Action":"MemoryCache/CacheStats/Access","HostProcessId":"6768","hits":"103","requests":"124","hitrate":"0.830645161290323","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"e53771a2-033e-4522-8a31-7ff489da8395","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000109"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:39.7704049Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":12,"Duration":"00:00:00.0000866"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:39.9325576Z","Action":"SimpleDocumentEvaluator/GetResult/Compile","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0033713"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:39.9333596Z","Action":"BackgroundThread/RollingTraceWriter/CleanupOldTraces","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":12,"Duration":"00:00:00.0032405"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:39.9391228Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":10,"Duration":"00:00:00.0001577"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:39.9360624Z","Action":"SqlTranslator/SqlParser/Parse","HostProcessId":"6768","SQL":"\nSELECT \nTOP (1000001) [t0].[companyid],[t0].[companyname],[t0].[agreementtype],[t0].[contracttype],[t0].[censusdate],[t0].[censuscount],[t0].[isnewimplementation],[t0].[isactive],[t0].[companypreviousinvoicedate],SUM([t0].[censuscount])\n AS [a0]\nFROM \n(\n(SELECT * FROM [monthendcensus])\n)\n AS [t0]\nWHERE \n(\n(\n(\n(\n(\n(\n(\n(\n(\n(\n(\n(\n[t0].[companyid] = N'HL101'\n)\n AND \n(\n[t0].[companyname] = N'Gentiva (IPU) - Mount Pleasant (CC#2641)'\n)\n)\n AND \n(\n[t0].[agreementtype] = N'NETWORK'\n)\n)\n AND \n(\n(\n[t0].[contracttype] = N'DME Days'\n)\n AND \n(\n[t0].[censusdate] = 20180430\n)\n)\n)\n AND \n(\n(\n(\n[t0].[censuscount] = 1\n)\n AND \n(\n[t0].[isnewimplementation] = 0\n)\n)\n AND \n(\n(\n[t0].[isactive] = 1\n)\n AND \n(\n[t0].[companypreviousinvoicedate] = 20180430\n)\n)\n)\n)\n OR \n(\n(\n(\n(\n(\n[t0].[companyid] = N'HL1128'\n)\n AND \n(\n[t0].[companyname] = N'Gentiva Hospice - Miramar Beach (CC#02974)'\n)\n)\n AND \n(\n[t0].[agreementtype] = N'NETWORK'\n)\n)\n AND \n(\n(\n[t0].[contracttype] = N'DME Days'\n)\n AND \n(\n[t0].[censusdate] = 20180430\n)\n)\n)\n AND \n(\n(\n(\n[t0].[censuscount] = 48\n)\n AND \n(\n[t0].[isnewimplementation] = 0\n)\n)\n AND \n(\n(\n[t0].[isactive] = 1\n)\n AND \n(\n[t0].[companypreviousinvoicedate] = 20180430\n)\n)\n)\n)\n)\n OR \n(\n(\n(\n(\n(\n(\n[t0].[companyid] = N'HL118'\n)\n AND \n(\n[t0].[companyname] = N'Gentiva Hospice - Marianna (CC#2501)'\n)\n)\n AND \n(\n[t0].[agreementtype] = N'NETWORK'\n)\n)\n AND \n(\n(\n[t0].[contracttype] = N'DME Days'\n)\n AND \n(\n[t0].[censusdate] = 20180430\n)\n)\n)\n AND \n(\n(\n(\n[t0].[censuscount] = 69\n)\n AND \n(\n[t0].[isnewimplementation] = 0\n)\n)\n AND \n(\n(\n[t0].[isactive] = 1\n)\n AND \n(\n[t0].[companypreviousinvoicedate] = 20180430\n)\n)\n)\n)\n OR \n(\n(\n(\n(\n(\n[t0].[companyid] = N'HL122'\n)\n AND \n(\n[t0].[companyname] = N'Kindred at Home - Dothan (CC#2498)'\n)\n)\n AND \n(\n[t0].[agreementtype] = N'NETWORK'\n)\n)\n AND \n(\n(\n[t0].[contracttype] = N'DME Days'\n)\n AND \n(\n[t0].[censusdate] = 20180430\n)\n)\n)\n AND \n(\n(\n(\n[t0].[censuscount] = 137\n)\n AND \n(\n[t0].[isnewimplementation] = 0\n)\n)\n AND \n(\n(\n[t0].[isactive] = 1\n)\n AND \n(\n[t0].[companypreviousinvoicedate] = 20180430\n)\n)\n)\n)\n)\n)\n OR \n(\n(\n(\n(\n(\n(\n(\n[t0].[companyid] = N'HL127'\n)\n AND \n(\n[t0].[companyname] = N'Kindred at Home - Florence (CC#2701)'\n)\n)\n AND \n(\n[t0].[agreementtype] = N'NETWORK'\n)\n)\n AND \n(\n(\n[t0].[contracttype] = N'DME Days'\n)\n AND \n(\n[t0].[censusdate] = 20180430\n)\n)\n)\n AND \n(\n(\n(\n[t0].[censuscount] = 89\n)\n AND \n(\n[t0].[isnewimplementation] = 0\n)\n)\n AND \n(\n(\n[t0].[isactive] = 1\n)\n AND \n(\n[t0].[companypreviousinvoicedate] = 20180430\n)\n)\n)\n)\n OR \n(\n(\n(\n(\n(\n[t0].[companyid] = N'HL1350'\n)\n AND \n(\n[t0].[companyname] = N'Gentiva Hospice - Orlando (FL)'\n)\n)\n AND \n(\n[t0].[agreementtype] = N'NETWORK'\n)\n)\n AND \n(\n(\n[t0].[contracttype] = N'DME Days'\n)\n AND \n(\n[t0].[censusdate] = 20180430\n)\n)\n)\n AND \n(\n(\n(\n[t0].[censuscount] = 206\n)\n AND \n(\n[t0].[isnewimplementation] = 0\n)\n)\n AND \n(\n(\n[t0].[isactive] = 1\n)\n AND \n(\n[t0].[companypreviousinvoicedate] = 20180430\n)\n)\n)\n)\n)\n OR \n(\n(\n(\n(\n(\n(\n[t0].[companyid] = N'HL1379'\n)\n AND \n(\n[t0].[companyname] = N'Kindred Hospice - Solon (OH)'\n)\n)\n AND \n(\n[t0].[agreementtype] = N'NETWORK'\n)\n)\n AND \n(\n(\n[t0].[contracttype] = N'DME Days'\n)\n AND \n(\n[t0].[censusdate] = 20180430\n)\n)\n)\n AND \n(\n(\n(\n[t0].[censuscount] = 87\n)\n AND \n(\n[t0].[isnewimplementation] = 0\n)\n)\n AND \n(\n(\n[t0].[isactive] = 1\n)\n AND \n(\n[t0].[companypreviousinvoicedate] = 20180430\n)\n)\n)\n)\n OR \n(\n(\n(\n(\n(\n[t0].[companyid] = N'HL1387'\n)\n AND \n(\n[t0].[companyname] = N'Gentiva Hospice - Tarboro (NC)'\n)\n)\n AND \n(\n[t0].[agreementtype] = N'NETWORK'\n)\n)\n AND \n(\n(\n[t0].[contracttype] = N'DME Days'\n)\n AND \n(\n[t0].[censusdate] = 20180430\n)\n)\n)\n AND \n(\n(\n(\n[t0].[censuscount] = 61\n)\n AND \n(\n[t0].[isnewimplementation] = 0\n)\n)\n AND \n(\n(\n[t0].[isactive] = 1\n)\n AND \n(\n[t0].[companypreviousinvoicedate] = 20180430\n)\n)\n)\n)\n)\n)\n)\n OR \n(\n(\n(\n(\n(\n(\n(\n(\n[t0].[companyid] = N'HL141'\n)\n AND \n(\n[t0].[companyname] = N'Kindred at Home - Montgomery (CC#2691)'\n)\n)\n AND \n(\n[t0].[agreementtype] = N'NETWORK'\n)\n)\n AND \n(\n(\n[t0].[contracttype] = N'DME Days'\n)\n AND \n(\n[t0].[censusdate] = 20180430\n)\n)\n)\n AND \n(\n(\n(\n[t0].[censuscount] = 137\n)\n AND \n(\n[t0].[isnewimplementation] = 0\n)\n)\n AND \n(","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0295542"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:39.9659094Z","Action":"DependencyCompiler/RegisterDataSources","HostProcessId":"6768","Kind":"AmazonRedshift","WasLoaded":"True","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000193"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:39.9993781Z","Action":"Engine/IO/Odbc/Connection/Open","HostProcessId":"6768","CurrentCatalog":null,"ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000068"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:39.9994492Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_NAME","Value":"Microsoft Amazon Redshift ODBC Driver","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0003871"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:39.9998606Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_VER","Value":"1.4.1.1002","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000166"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:39.9998840Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DBMS_NAME","Value":"Redshift","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000063"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:39.9998947Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DBMS_VER","Value":"8.0.2","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000061"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:39.9994453Z","Action":"Engine/IO/Odbc/Connection/Info","HostProcessId":"6768","DriverName":"Microsoft Amazon Redshift ODBC Driver","DriverVersion":"1.4.1.1002","DBMSName":"Redshift","DBMSVersion":"8.0.2","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0005658"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0000214Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_IDENTIFIER_QUOTE_CHAR","Value":"\"","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000089"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0000356Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_SCHEMA_USAGE","Value":"29","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000070"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0000471Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_CATALOG_USAGE","Value":"1","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000059"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0000575Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_CATALOG_NAME_SEPARATOR","Value":".","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000055"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0000680Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_CATALOG_LOCATION","Value":"1","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000054"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0000776Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_SQL_CONFORMANCE","Value":"1","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000061"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0000878Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_MAX_COLUMNS_IN_ORDER_BY","Value":"0","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000052"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0000983Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_MAX_IDENTIFIER_LEN","Value":"64","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000055"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0001079Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_MAX_COLUMNS_IN_GROUP_BY","Value":"0","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000060"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0001384Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_MAX_COLUMNS_IN_SELECT","Value":"0","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000076"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0001517Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_ORDER_BY_COLUMNS_IN_SELECT","Value":"N","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000057"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0001628Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_STRING_FUNCTIONS","Value":"14680063","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000086"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0001778Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_AGGREGATE_FUNCTIONS","Value":"127","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000079"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0001902Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_SQL92_PREDICATES","Value":"16007","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000054"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0002002Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_SQL92_RELATIONAL_JOIN_OPERATORS","Value":"1022","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000053"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0002097Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_COLUMN_ALIAS","Value":"Y","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000064"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0002202Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_GROUP_BY","Value":"1","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000051"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0002300Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_NUMERIC_FUNCTIONS","Value":"16777215","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000053"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0002394Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_TIMEDATE_FUNCTIONS","Value":"2097151","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000062"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0002535Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_SYSTEM_FUNCTIONS","Value":"7","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000069"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0002816Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_TIMEDATE_ADD_INTERVALS","Value":"511","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000076"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0002947Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_TIMEDATE_DIFF_INTERVALS","Value":"511","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000054"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0003043Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_CONCAT_NULL_BEHAVIOR","Value":"1","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000059"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0003146Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_CATALOG_NAME","Value":"Y","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000056"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0003249Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_CATALOG_TERM","Value":"catalog","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000053"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0003343Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_SCHEMA_TERM","Value":"schema","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000057"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0003442Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_ODBC_INTERFACE_CONFORMANCE","Value":"1","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000054"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0003543Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_SEARCH_PATTERN_ESCAPE","Value":"\\","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000156"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0003755Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_CONVERT_FUNCTIONS","Value":"3","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000055"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0003857Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_CONVERT_BIGINT","Value":"17407","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000060"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0004118Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_CONVERT_BINARY","Value":"1793","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000074"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0004249Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_CONVERT_BIT","Value":"4873","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000055"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0004347Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_CONVERT_CHAR","Value":"17029087","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000058"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0004453Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_CONVERT_DECIMAL","Value":"17407","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000052"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0004555Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_CONVERT_DOUBLE","Value":"17407","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000054"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0004655Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_CONVERT_FLOAT","Value":"17407","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000053"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0004750Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_CONVERT_GUID","Value":"31461121","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000062"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0004856Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_CONVERT_INTEGER","Value":"21503","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000052"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0004961Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_CONVERT_LONGVARBINARY","Value":"0","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000054"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0005057Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_CONVERT_LONGVARCHAR","Value":"17031135","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000058"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0005159Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_CONVERT_NUMERIC","Value":"17407","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000053"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0005399Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_CONVERT_REAL","Value":"17407","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000074"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0005523Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_CONVERT_SMALLINT","Value":"21503","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000060"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0005626Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_CONVERT_TIMESTAMP","Value":"230145","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000060"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0005727Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_CONVERT_TINYINT","Value":"0","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000052"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0005828Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_CONVERT_DATE","Value":"164609","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000053"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0005930Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_CONVERT_TIME","Value":"66305","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000059"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0006035Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_CONVERT_VARBINARY","Value":"2817","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000052"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0006134Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_CONVERT_VARCHAR","Value":"17031135","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000052"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0006234Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_CONVERT_WCHAR","Value":"0","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000054"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0006330Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_CONVERT_WLONGVARCHAR","Value":"0","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000060"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0006573Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_CONVERT_WVARCHAR","Value":"0","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000070"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0006704Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_SPECIAL_CHARACTERS","Value":"_","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000057"}
DataMashup.Trace Error: 24579 : {"Start":"2018-05-31T20:22:40.0006805Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","HostProcessId":"6768","InfoType":"SQL_RETURN_ESCAPE_CLAUSE","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Library.Odbc.Interop.OdbcException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: ERROR [HY096] [Microsoft][ODBC] (11180) SQLGetInfo property not found: 180\r\nStackTrace:\n at Microsoft.Mashup.Engine1.Library.Odbc.OdbcCachingService.OdbcCachingConnection.OdbcFunctionCaching.GetResult[Output](UInt16 input, Func`3 function)\r\n at Microsoft.Mashup.Engine1.Library.Odbc.OdbcTracingService.OdbcTracingConnection.<>c__DisplayClass8.<GetInfoInt32>b__7(IHostTrace trace)\r\n at Microsoft.Mashup.Engine1.Library.Common.Tracer.Trace[T](String method, Func`2 func)\r\n\r\n\r\n","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0002155"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0009245Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_ODBC_VER","Value":"03.80","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000184"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:39.9993429Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"6768","Attempt":"0","MaxAttempt":"3","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0016113"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:39.9993213Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0016405"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0010999Z","Action":"Engine/IO/Odbc/Connection/Open","HostProcessId":"6768","CurrentCatalog":null,"ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000048"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0011173Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_NAME","Value":"Microsoft Amazon Redshift ODBC Driver","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000270"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0011508Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_VER","Value":"1.4.1.1002","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000060"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0011914Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DBMS_NAME","Value":"Redshift","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000085"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0012051Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DBMS_VER","Value":"8.0.2","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000053"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0011135Z","Action":"Engine/IO/Odbc/Connection/Info","HostProcessId":"6768","DriverName":"Microsoft Amazon Redshift ODBC Driver","DriverVersion":"1.4.1.1002","DBMSName":"Redshift","DBMSVersion":"8.0.2","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0001049"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0012237Z","Action":"Engine/IO/Odbc/Command/GetTables","HostProcessId":"6768","CatalogName":"%","SchemaName":"","TableName":"","TableType":"","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000323"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0010850Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"6768","Attempt":"0","MaxAttempt":"3","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0001861"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0010785Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0001981"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0030109Z","Action":"Engine/IO/Odbc/Connection/Open","HostProcessId":"6768","CurrentCatalog":null,"ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000290"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0030704Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_NAME","Value":"Microsoft Amazon Redshift ODBC Driver","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000342"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0031116Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_VER","Value":"1.4.1.1002","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000072"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0031237Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DBMS_NAME","Value":"Redshift","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000053"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0033518Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DBMS_VER","Value":"8.0.2","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000319"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0030656Z","Action":"Engine/IO/Odbc/Connection/Info","HostProcessId":"6768","DriverName":"Microsoft Amazon Redshift ODBC Driver","DriverVersion":"1.4.1.1002","DBMSName":"Redshift","DBMSVersion":"8.0.2","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0003334"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0034070Z","Action":"Engine/IO/Odbc/Command/GetTables","HostProcessId":"6768","CatalogName":"%","SchemaName":null,"TableName":null,"TableType":"TABLE,VIEW","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000356"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0029856Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"6768","Attempt":"0","MaxAttempt":"3","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0004851"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0029658Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0005106"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0036475Z","Action":"Engine/IO/Odbc/Connection/Open","HostProcessId":"6768","CurrentCatalog":null,"ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000053"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0036649Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_NAME","Value":"Microsoft Amazon Redshift ODBC Driver","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000176"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0036885Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_VER","Value":"1.4.1.1002","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000058"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0036992Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DBMS_NAME","Value":"Redshift","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000054"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0037093Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DBMS_VER","Value":"8.0.2","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000053"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0036618Z","Action":"Engine/IO/Odbc/Connection/Info","HostProcessId":"6768","DriverName":"Microsoft Amazon Redshift ODBC Driver","DriverVersion":"1.4.1.1002","DBMSName":"Redshift","DBMSVersion":"8.0.2","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0001357"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0039276Z","Action":"Engine/IO/Odbc/Command/GetColumns","HostProcessId":"6768","CatalogName":"nmdw","SchemaName":"public","TableName":"monthendcensus","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000402"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0036341Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"6768","Attempt":"0","MaxAttempt":"3","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0003737"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0036279Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0003869"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0040386Z","Action":"Engine/IO/Odbc/Connection/Open","HostProcessId":"6768","CurrentCatalog":null,"ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000049"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0040519Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_NAME","Value":"Microsoft Amazon Redshift ODBC Driver","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000169"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0040743Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_VER","Value":"1.4.1.1002","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000069"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0040856Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DBMS_NAME","Value":"Redshift","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000053"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0040957Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DBMS_VER","Value":"8.0.2","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000053"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0040491Z","Action":"Engine/IO/Odbc/Connection/Info","HostProcessId":"6768","DriverName":"Microsoft Amazon Redshift ODBC Driver","DriverVersion":"1.4.1.1002","DBMSName":"Redshift","DBMSVersion":"8.0.2","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000591"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0040256Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"6768","Attempt":"0","MaxAttempt":"3","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0001814"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0040212Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0002315"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0042976Z","Action":"Engine/IO/Odbc/Connection/Open","HostProcessId":"6768","CurrentCatalog":null,"ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000068"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0043191Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_NAME","Value":"Microsoft Amazon Redshift ODBC Driver","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000261"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0043540Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_VER","Value":"1.4.1.1002","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000562"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0044231Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DBMS_NAME","Value":"Redshift","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000099"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0044396Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DBMS_VER","Value":"8.0.2","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000102"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0043143Z","Action":"Engine/IO/Odbc/Connection/Info","HostProcessId":"6768","DriverName":"Microsoft Amazon Redshift ODBC Driver","DriverVersion":"1.4.1.1002","DBMSName":"Redshift","DBMSVersion":"8.0.2","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0001459"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0045665Z","Action":"Engine/IO/Odbc/Connection/GetFunctions","HostProcessId":"6768","FunctionId":"SQL_API_SQLPRIMARYKEYS","Value":"True","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000277"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0046096Z","Action":"Engine/IO/Odbc/Command/GetPrimaryKeys","HostProcessId":"6768","CatalogName":"nmdw","SchemaName":"public","TableName":"monthendcensus","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000253"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0042821Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"6768","Attempt":"0","MaxAttempt":"3","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0003641"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0042724Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0004048"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0047103Z","Action":"Engine/IO/Odbc/Connection/Open","HostProcessId":"6768","CurrentCatalog":null,"ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000041"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0047236Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_NAME","Value":"Microsoft Amazon Redshift ODBC Driver","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000143"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0047465Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_VER","Value":"1.4.1.1002","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000088"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0047611Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DBMS_NAME","Value":"Redshift","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000088"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0047756Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DBMS_VER","Value":"8.0.2","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000084"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0047208Z","Action":"Engine/IO/Odbc/Connection/Info","HostProcessId":"6768","DriverName":"Microsoft Amazon Redshift ODBC Driver","DriverVersion":"1.4.1.1002","DBMSName":"Redshift","DBMSVersion":"8.0.2","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000722"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0047984Z","Action":"Engine/IO/Odbc/Connection/GetFunctions","HostProcessId":"6768","FunctionId":"SQL_API_SQLFOREIGNKEYS","Value":"True","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000129"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0048166Z","Action":"Engine/IO/Odbc/Command/GetForeignKeys","HostProcessId":"6768","PKCatalogName":null,"PKSchemaName":null,"PKTableName":null,"FKCatalogName":"nmdw","FKSchemaName":"public","FKTableName":"monthendcensus","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000176"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0046993Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"6768","Attempt":"0","MaxAttempt":"3","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0001439"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0046948Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0001725"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0048863Z","Action":"Engine/IO/Odbc/Connection/Open","HostProcessId":"6768","CurrentCatalog":null,"ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000047"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0048984Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_NAME","Value":"Microsoft Amazon Redshift ODBC Driver","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000141"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0049175Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DRIVER_VER","Value":"1.4.1.1002","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000057"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0049279Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DBMS_NAME","Value":"Redshift","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000052"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0049369Z","Action":"Engine/IO/Odbc/Connection/GetInfoString","HostProcessId":"6768","InfoType":"SQL_DBMS_VER","Value":"8.0.2","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000055"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0048958Z","Action":"Engine/IO/Odbc/Connection/Info","HostProcessId":"6768","DriverName":"Microsoft Amazon Redshift ODBC Driver","DriverVersion":"1.4.1.1002","DBMSName":"Redshift","DBMSVersion":"8.0.2","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000532"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0049546Z","Action":"Engine/IO/Odbc/Connection/GetFunctions","HostProcessId":"6768","FunctionId":"SQL_API_SQLFOREIGNKEYS","Value":"True","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000113"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0049709Z","Action":"Engine/IO/Odbc/Command/GetForeignKeys","HostProcessId":"6768","PKCatalogName":"nmdw","PKSchemaName":"public","PKTableName":"monthendcensus","FKCatalogName":null,"FKSchemaName":null,"FKTableName":null,"ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000171"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0048779Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"6768","Attempt":"0","MaxAttempt":"3","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0001186"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.0048731Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0001453"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:39.9657666Z","Action":"SqlExpressionTranslator/Translate","HostProcessId":"6768","IsRecognized":"True","Result":"(environment) => Table.RenameColumns(let\r\n t4257 = Table.RenameColumns(Table.PrefixColumns(environment[monthendcensus], \"monthendcensus\"), {{\"monthendcensus.companyid\", \"t0.companyid\"}, {\"monthendcensus.companyname\", \"t0.companyname\"}, {\"monthendcensus.agreementtype\", \"t0.agreementtype\"}, {\"monthendcensus.contracttype\", \"t0.contracttype\"}, {\"monthendcensus.censusdate\", \"t0.censusdate\"}, {\"monthendcensus.censuscount\", \"t0.censuscount\"}, {\"monthendcensus.isnewimplementation\", \"t0.isnewimplementation\"}, {\"monthendcensus.isactive\", \"t0.isactive\"}, {\"monthendcensus.companypreviousinvoicedate\", \"t0.companypreviousinvoicedate\"}}),\r\n t4259 = ((table) => Table.SelectRows(table, (t4258) => Value.NullableEquals(t4258[t0.companyid], \"HL101\") and Value.NullableEquals(t4258[t0.companyname], \"Gentiva (IPU) - Mount Pleasant (CC#2641)\") and Value.NullableEquals(t4258[t0.agreementtype], \"NETWORK\") and (Value.NullableEquals(t4258[t0.contracttype], \"DME Days\") and Value.NullableEquals(t4258[t0.censusdate], 20180430)) and (Value.NullableEquals(t4258[t0.censuscount], 1) and Value.NullableEquals(Int64.From(t4258[t0.isnewimplementation]), 0) and (Value.NullableEquals(Int64.From(t4258[t0.isactive]), 1) and Value.NullableEquals(t4258[t0.companypreviousinvoicedate], 20180430))) or Value.NullableEquals(t4258[t0.companyid], \"HL1128\") and Value.NullableEquals(t4258[t0.companyname], \"Gentiva Hospice - Miramar Beach (CC#02974)\") and Value.NullableEquals(t4258[t0.agreementtype], \"NETWORK\") and (Value.NullableEquals(t4258[t0.contracttype], \"DME Days\") and Value.NullableEquals(t4258[t0.censusdate], 20180430)) and (Value.NullableEquals(t4258[t0.censuscount], 48) and Value.NullableEquals(Int64.From(t4258[t0.isnewimplementation]), 0) and (Value.NullableEquals(Int64.From(t4258[t0.isactive]), 1) and Value.NullableEquals(t4258[t0.companypreviousinvoicedate], 20180430))) or (Value.NullableEquals(t4258[t0.companyid], \"HL118\") and Value.NullableEquals(t4258[t0.companyname], \"Gentiva Hospice - Marianna (CC#2501)\") and Value.NullableEquals(t4258[t0.agreementtype], \"NETWORK\") and (Value.NullableEquals(t4258[t0.contracttype], \"DME Days\") and Value.NullableEquals(t4258[t0.censusdate], 20180430)) and (Value.NullableEquals(t4258[t0.censuscount], 69) and Value.NullableEquals(Int64.From(t4258[t0.isnewimplementation]), 0) and (Value.NullableEquals(Int64.From(t4258[t0.isactive]), 1) and Value.NullableEquals(t4258[t0.companypreviousinvoicedate], 20180430))) or Value.NullableEquals(t4258[t0.companyid], \"HL122\") and Value.NullableEquals(t4258[t0.companyname], \"Kindred at Home - Dothan (CC#2498)\") and Value.NullableEquals(t4258[t0.agreementtype], \"NETWORK\") and (Value.NullableEquals(t4258[t0.contracttype], \"DME Days\") and Value.NullableEquals(t4258[t0.censusdate], 20180430)) and (Value.NullableEquals(t4258[t0.censuscount], 137) and Value.NullableEquals(Int64.From(t4258[t0.isnewimplementation]), 0) and (Value.NullableEquals(Int64.From(t4258[t0.isactive]), 1) and Value.NullableEquals(t4258[t0.companypreviousinvoicedate], 20180430)))) or (Value.NullableEquals(t4258[t0.companyid], \"HL127\") and Value.NullableEquals(t4258[t0.companyname], \"Kindred at Home - Florence (CC#2701)\") and Value.NullableEquals(t4258[t0.agreementtype], \"NETWORK\") and (Value.NullableEquals(t4258[t0.contracttype], \"DME Days\") and Value.NullableEquals(t4258[t0.censusdate], 20180430)) and (Value.NullableEquals(t4258[t0.censuscount], 89) and Value.NullableEquals(Int64.From(t4258[t0.isnewimplementation]), 0) and (Value.NullableEquals(Int64.From(t4258[t0.isactive]), 1) and Value.NullableEquals(t4258[t0.companypreviousinvoicedate], 20180430))) or Value.NullableEquals(t4258[t0.companyid], \"HL1350\") and Value.NullableEquals(t4258[t0.companyname], \"Gentiva Hospice - Orlando (FL)\") and Value.NullableEquals(t4258[t0.agreementtype], \"NETWORK\") and (Value.NullableEquals(t4258[t0.contracttype], \"DME Days\") and Value.NullableEquals(t4258[t0.censusdate], 20180430)) and (Value.NullableEquals(t4258[t0.censuscount], 206) and Value.NullableEquals(Int64.From(t4258[t0.isnewimplementation]), 0) and (Value.NullableEquals(Int64.Fr","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0695574"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:39.9680235Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":12,"Duration":"00:00:00.2249835"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.2170535Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":10,"Duration":"00:00:00.0001806"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:39.9360114Z","Action":"SimpleDocumentEvaluator/GetResult/Evaluate","HostProcessId":"6768","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.2898372"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.2293534Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":12,"Duration":"00:00:00.0000680"}
DataMashup.Trace Warning: 24579 : {"Start":"2018-05-31T20:22:40.3244629Z","Action":"OdbcQuery/FoldingWarning","HostProcessId":"6768","Function Name":"VisitBinary","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000207"}
DataMashup.Trace Warning: 24579 : {"Start":"2018-05-31T20:22:40.3295773Z","Action":"OdbcQuery/FoldingWarning","HostProcessId":"6768","Function Name":"VisitBinary","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000295"}
DataMashup.Trace Warning: 24579 : {"Start":"2018-05-31T20:22:40.3296438Z","Action":"OdbcQuery/FoldingWarning","HostProcessId":"6768","Function Name":"VisitBinary","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000054"}
DataMashup.Trace Warning: 24579 : {"Start":"2018-05-31T20:22:40.3296574Z","Action":"OdbcQuery/FoldingWarning","HostProcessId":"6768","Function Name":"VisitBinary","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000043"}
DataMashup.Trace Warning: 24579 : {"Start":"2018-05-31T20:22:40.3296672Z","Action":"OdbcQuery/FoldingWarning","HostProcessId":"6768","Function Name":"VisitBinary","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000056"}
DataMashup.Trace Warning: 24579 : {"Start":"2018-05-31T20:22:40.3296790Z","Action":"OdbcQuery/FoldingWarning","HostProcessId":"6768","Function Name":"VisitBinary","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000042"}
DataMashup.Trace Warning: 24579 : {"Start":"2018-05-31T20:22:40.3297522Z","Action":"OdbcQuery/FoldingWarning","HostProcessId":"6768","Function Name":"VisitInvocation","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000085"}
DataMashup.Trace Warning: 24579 : {"Start":"2018-05-31T20:22:40.3297682Z","Action":"OdbcQuery/FoldingWarning","HostProcessId":"6768","Function Name":"VisitValueEqualsShared","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000042"}
DataMashup.Trace Warning: 24579 : {"Start":"2018-05-31T20:22:40.3297783Z","Action":"OdbcQuery/FoldingWarning","HostProcessId":"6768","Function Name":"VisitInvocation","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000041"}
DataMashup.Trace Warning: 24579 : {"Start":"2018-05-31T20:22:40.3298157Z","Action":"OdbcQuery/FoldingWarning","HostProcessId":"6768","Function Name":"VisitNumberTypeFromFunction","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000120"}
DataMashup.Trace Warning: 24579 : {"Start":"2018-05-31T20:22:40.3298408Z","Action":"OdbcQuery/FoldingWarning","HostProcessId":"6768","ErrorMessage":"Failed to convert from bool to int8 for expression \"isnewimplementation\". You can override this by using SqlGetInfo for converting from BIT to BIGINT.","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000923"}
DataMashup.Trace Warning: 24579 : {"Start":"2018-05-31T20:22:40.3299428Z","Action":"OdbcQuery/FoldingWarning","HostProcessId":"6768","ErrorMessage":"The SoftNumbers feature has not been set. You can override it by using the option parameter in Odbc.DataSource/Odbc.Query.","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000107"}
DataMashup.Trace Warning: 24579 : {"Start":"2018-05-31T20:22:40.3300469Z","Action":"OdbcQueryDomain/ReportFoldingFailure","HostProcessId":"6768","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Runtime.FoldingFailureException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: Folding failed. Please take a look the information in the trace.\r\nStackTrace:\n at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQueryExpressionVisitor.VisitNumberTypeFromFunction(InvocationQueryExpression expression, Boolean isInt)\r\n at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQueryExpressionVisitor.VisitInvocation(InvocationQueryExpression expression)\r\n at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQueryExpressionVisitor.VisitValueEqualsShared(InvocationQueryExpression expression, Boolean nullable)\r\n at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQueryExpressionVisitor.VisitInvocation(InvocationQueryExpression expression)\r\n at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQueryExpressionVisitor.VisitBinary(BinaryQueryExpression binaryExpression)\r\n at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQueryExpressionVisitor.VisitBinary(BinaryQueryExpression binaryExpression)\r\n at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQueryExpressionVisitor.VisitBinary(BinaryQueryExpression binaryExpression)\r\n at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQueryExpressionVisitor.VisitBinary(BinaryQueryExpression binaryExpression)\r\n at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQueryExpressionVisitor.VisitBinary(BinaryQueryExpression binaryExpression)\r\n at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQueryExpressionVisitor.VisitBinary(BinaryQueryExpression binaryExpression)\r\n at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQuery.SelectRows(FunctionValue function)\r\n\r\n\r\n","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0001315"}
DataMashup.Trace Warning: 24579 : {"Start":"2018-05-31T20:22:40.2286206Z","Action":"RemotePageReader/RunStub","HostProcessId":"6768","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Runtime.ValueException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: [Expression.Error] We couldn't fold the expression to the data source. Please try a simpler expression.\r\nStackTrace:\n at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQueryDomain.ReportFoldingFailure(NotSupportedException ex)\r\n at Microsoft.Mashup.Engine1.Library.Odbc.OdbcQuery.SelectRows(FunctionValue function)\r\n at Microsoft.Mashup.Engine1.Runtime.OptimizingQueryVisitor.VisitQuery(Query query, Func`2 operation)\r\n at Microsoft.Mashup.Engine1.Runtime.OptimizingQueryVisitor.VisitQuery(Query query)\r\n at Microsoft.Mashup.Engine1.Runtime.OptimizingQueryVisitor.VisitQuery(Query query, Func`2 operation)\r\n at Microsoft.Mashup.Engine1.Runtime.OptimizingQueryVisitor.VisitQuery(Query query)\r\n at Microsoft.Mashup.Engine1.Runtime.OptimizingQueryVisitor.VisitQuery(Query query, Func`2 operation)\r\n at Microsoft.Mashup.Engine1.Runtime.OptimizingQueryVisitor.VisitQuery(Query query)\r\n at Microsoft.Mashup.Engine1.Runtime.OptimizingQueryVisitor.Optimize(Query query)\r\n at Microsoft.Mashup.Engine1.Language.Query.QueryTableValue.get_OptimizedQuery()\r\n at Microsoft.Mashup.Engine1.Language.Query.QueryTableValue.GetReader()\r\n at Microsoft.Mashup.Engine.Interface.Tracing.TracingDataReaderSource.get_PageReader()\r\n at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.<>c__DisplayClass11.<>c__DisplayClass13.<OnBeginGetDataReaderSource>b__10()\r\n at Microsoft.Mashup.Evaluator.RemotePageReader.<>c__DisplayClass7.<RunStub>b__0()\r\n at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)\r\n\r\n\r\n","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.1020642"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:39.9318743Z","Action":"RemoteDocumentEvaluator/Service/OnBeginGetResult","HostProcessId":"6768","evaluationID":"3563","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.3988376"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.3312213Z","Action":"DependencyCompiler/Dispose","HostProcessId":"6768","AmazonRedshift":"True","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000133"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.3312746Z","Action":"MemoryCache/CacheStats/Size","HostProcessId":"6768","entryCount":"21","totalSize":"40203","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000060"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.3312875Z","Action":"MemoryCache/CacheStats/Access","HostProcessId":"6768","hits":"104","requests":"125","hitrate":"0.832","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"4d0e0e7f-6f7a-4936-ae73-89f251bf42ee","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":1,"Duration":"00:00:00.0000111"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T20:22:40.4262928Z","Action":"BackgroundThread/RollingTraceWriter/Flush","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":12,"Duration":"00:00:00.0003488"}
DataMashup.Trace Information: 24579 : {"Start":"2018-05-31T21:55:18.1461934Z","Action":"EvaluationHost/TryHandleException","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":3,"Duration":"00:00:00.0190987"}
DataMashup.Trace Error: 24579 : {"Start":"2018-05-31T21:55:18.1684628Z","Action":"EvaluationContainerMain/ExceptionHandler/HandleException","containerID":"21","Exception":"Exception:\r\nExceptionType: System.Threading.AbandonedMutexException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: The wait completed due to an abandoned mutex.\r\nStackTrace:\n at System.Threading.WaitHandle.ThrowAbandonedMutexException()\r\n at System.Threading.WaitHandle.InternalWaitOne(SafeHandle waitableSafeHandle, Int64 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext)\r\n at System.Threading.WaitHandle.WaitOne(Int32 millisecondsTimeout, Boolean exitContext)\r\n at Microsoft.Mashup.Container.EvaluationContainerMain.WaitForParentExitThread(Object state)\r\n at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass15.<CreateAction>b__14(Object o)\r\n\r\n\r\n","ProductVersion":"2.58.5103.501 (PBIDesktop)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1264,"Tid":3,"Duration":"00:00:00.0003542"}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment