Here’s a new feature for DBsandBI.com – a weekly update of what I’m working on.
1. All client/server connections, for BI, to our AS400 via ODBC needs to be set to read only and have the commit mode set to Commit immediate (*NONE) instead of the default Read Uncommitted (*CHG)- This was causing locks [...]
I went to open a frame work on our development server today and I got the following error:
BME-EX-0047 Unable to read preferences for the requested interface. Please use another repository and/or ProjectAccess Interface.
The same thing had happened earlier this year. The same thing worked to fix it. If you’ve only got one environment, [...]
One of my the biggest things on my “to do list” for this site is to make it easy for readers to subscribe. I’ll be adding links to the main page, but in the mean time, here’s the links for right now:
Here’s the feed for my blog:http://www.dbsandbi.com/Blog/rss.xml
Here’s the feed for the News page:http://www.google.com/reader/public/atom/user/14135896925018987441/label/z_DBsandBI
After quite a few nights of babysitting ETL loads and verifying cubes builds completing successfully, the new and improved DBsandBI.com is up and going.
There is still a bit of work that needs to be done, but this is the basic structure for now. There is a links page, a blog, an about me page, [...]
While researching an issue we were having, I really started studying the COGIPF_RUNREPORT table and found the COGIPF_LOCALTIMESTAMP column has the start time of the report while the report is running and the end time once the report completes. Note the COGIPF_RUNTIME will be 0 while the report is running. Thus I’ve [...]