on 07-04-2016 5:37 AM
Hi, I have built a time series model with the Analytics Server/Modeler and saved the model in a SQL Server database. I can read the model back into the Modeler from the database so I know I have a working connection to the database.
I have also created a project in the Predictive Factory and when I try to load the model into it I can see the model listed as available but I always get the following, completely unhelpful, error message:
Task Model Import ended with errors.
I can't find any log files through the UI for the Predictive Factory that might help me understand what the errors are. I believe I have correct authentication for the database otherwise I would assume that I could not see the model listed as available for import.
Can anyone help?
Thanks,
Andrew.
Update: Andrew & I are working on this offline. We will update the thread once we reach a conclusion.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kevin,
In my case, the problem was using a sequential integer variable for the time variable. My intention was to represent seconds or sub-second time intervals. This works when building a time series model in Automated Analytics, but it does not work within the Predictive Factory. The Predictive Factory appears to require a date/time class for the time variable, whereas the Automated Analytics does not. Antoine and his team provided me with a lot of off-line support to understand what was causing the problem and I believe their development team is looking into it.
Hi Kevin,
If you are having the same problem as I was, you will need to use a correctly formatted date/time variable for the model to work in Predictive Factory. The main issue for me was that the date/time class used in both Automated Analytics and Predictive Factory cannot handle sub-second time intervals - at least that's my understanding. If you aren't using sub-second time intervals then recoding your time variable to the correct date/time format should fix the problem for you.
Thanks Andrew- but this did not work for me unfortunately. I went back and stripped all time related data out so i was only left with date (YYYY/MM/DD) and in automated analytics I had no problem which I would expect. However, I am still getting errors (with no explanation) when I try to import that same model into Factory. Have you gotten any time series model to work in factory?
Hi Kevin,
Sorry to hear you're still having problems. When I had this problem, I was trying to build a system to demonstrate automated model maintenance (via Predictive Factory) for a predictive maintenance proof-of-concept project. I ended up creating an application with R and Shiny instead because I couldn't get the Predictive Factory to work for me. So I never tried loading a time series model into it which used dates as the time variable. So unfortunately I have no other suggestions or ideas for you. The only idea I have left is for you to check that your time variable has perfectly consistent sampling intervals. If the intervals are not regular, then that may cause problems. Other than that, I'd have to hand this over to the SAP folks to try to sort out.
Sorry I can't help any further and good luck. I'd be very interested to hear how this turns out.
Andrew.
Hi Andrew, the log files from the Predictive Factory are stored by default here: C:\Program Files (x86)\SAP BI\Analytics\logging, if you installed the Predictive Factory in the default installation folder.
I'll send more detailed explanation of what the different log files, but you might want to open the *.glf files to see if you find more explanation related to the error.
I also recommend to log a ticket with SAP Support so that you can be helped with the investigations. Zip the content of the logging folder that I referenced and please include it as an attachment to your ticket.
Best regards
Antoine
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Antoine,
Thanks for your rapid reply. I've found what I believe is the relevant log file but it doesn't mean much to me, other than saying that it could not parse data from the store I am using.
I'll log a ticket with SAP Support, as you suggested, but will have to figure out some kind of hack to get this working for an upcoming demo.
Thanks again,
Andrew.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.