zoveress's avatar
zoveress
Regular Visitor
9 years ago
Status:
Needs Info

Db2 10.5 - Couldn't load the model schema.

Hello,

 

I am trying to get data from our linux based DB2 10.5 server. Full version:

 

uses "64" bits and DB2 code release "SQL10056" with level identifier
"0607010E".
Informational tokens are "DB2 v10.5.0.6", "s150731", "IP23643", and Fix Pack
"6".

 

The data loads for a while then it throws an unexpected error with the following details:

 

Feedback Type:
Frown (Error)

Timestamp:
2017-09-01T06:47:34.3915191Z

Local Time:
2017-09-01T08:47:34.3915191+02:00

Product Version:
2.49.4831.521 (PBIDesktop) (x64)

Release:
August 2017

IE Version:
11.0.9600.17031

OS Version:
Microsoft Windows NT 6.3.9600.0 (x64 en-US)

CLR Version:
4.6.2. or later [Release Number = 394806]

Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Peak Working Set:
475 MB

Private Memory:
312 MB

Peak Virtual Memory:
1.7 GB

Error Message:
Couldn't load the model schema.

User ID:
24a5f5db-e5b3-4999-a5ca-317a66cb88b1

Session ID:
9fa5f65e-5f28-463d-a0b4-43f9b9832a57

Telemetry Enabled:
True

Model Default Mode:
Import

Snapshot Trace Logs:
C:\Users\Administrator\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1915329033.zip

Performance Trace Logs:
C:\Users\Administrator\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_numericSlicerEnabled
PBI_SpanishLinguisticsEnabled
PBI_daxTemplatesEnabled
CustomConnectors

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted

Cloud:
GlobalCloud

Couldn't load the schema for the database model:
Couldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again.

Activity ID:
null

Time:
Fri Sep 01 2017 08:47:08 GMT+0200 (Central Europe Daylight Time)

DPI Scale:
100%

Supported Services:
Power BI

Formulas:


section Section1;

shared #"ITMUSER LP_K59AVAIL" = let
    Source = DB2.Database("172.25.50.4:50000", "warehous", [Implementation="Microsoft", CreateNavigationProperties=false]),
    ITMUSER_LP_K59AVAIL = Source{[Schema="ITMUSER",Item="LP_K59AVAIL"]}[Data]
in
    ITMUSER_LP_K59AVAIL;

shared #"ITMUSER Application_Server_Status_MV" = let
    Source = DB2.Database("172.25.50.4:50000", "warehous", [Implementation="Microsoft"]),
    ITMUSER_Application_Server_Status_MV = Source{[Schema="ITMUSER",Item="Application_Server_Status_MV"]}[Data]
in
    ITMUSER_Application_Server_Status_MV;

 

Doesn't matter which driver I chose .NET or DB2 the issue is the same. Any ideas?

3 Comments