SmartList Builder and Extender Resources
JenniferW asked 9 years ago
So, recently we upgraded to GP2013 and at that time upgraded our Extender to eOne's Extender Enterprise. Now, if I try to use an Extender resource in a SmartList Builder report I have one window that will not work in a report. I turned on the DEXSQL.log and the error I get is this –
/* Date: 10/22/2013 Time: 8:14:22
stmt(14040568):*/
select top 1000 T1.[_1] K1, T1.[_1],T1.[County_100] from (select C.Extender_Record_ID, C.[_1], C.[County_100] from (select Extender_Record_ID, Extender_Key_Values_1 as [_1], Extender_Key_Values_100 as [County_100] from EAGLE..EXT01100 where Extender_Window_ID = 'CUST_COUNTY') C ) T1
/*
/* Date: 10/22/2013 Time: 8:14:22
SQLSTATE:(S0022) Native Err:(207) stmt(14040568):*/
[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'Extender_Key_Values_100'.*/
/*
I did try and drop and re-create the stored procedures but still get this error. Any idea of how to fix it?
Thanks
Jennifer
Answers
Best Answer
Nicole answered 9 years ago
JenniferW replied 9 years ago
Nicole answered 9 years ago
It appears that the SmartList Builder setup is still trying to pull in some of the old information from 2010 or 10, which ever you have updated from.
Can you try removing the Extender Window from the SmartList Builder setup and then re-adding it to the setup? Then see if you are still getting the same results.
I am assuming that you are adding a Window to SLB using the Extender Resource option and not adding a SQL View built in Extender, correct?
JenniferW replied 9 years ago Hi Nicole
I am adding the window to a SLB report using the Extender Resource option. What do you mean by removing the Extender Window from the SLB setup? I don't see an option to do that. I was just trying to build a new SLB report and add the Extender window to it and I get no results and the error shows in the DEXSQL log. So, if you could tell me how to remove and re-add the window I would appreciate it.
Thanks
Jennifer
Nicole answered 9 years ago
There is a minus sign in the top corner of the tables section on the SLB setup. If you can remove the Extender Window using that option and then add it back again using the plus sign, that would be a good test. You could also just try adding it to a new SLB setup if you haven’t already.
If the new one doesn’t work, we would probably need to look at it with the support team. You can e-mail them the setup you have in Extender and they can test it on their environment. If you want to go this route, you can e-mail it to support@eonesolutions.com.
JenniferW replied 9 years ago Hi Nicole
Yeah, I had already tried removing the Extender resource and adding it back in and also tried creating a new SLB report and putting just the Extender resource in and still no luck. I will email what I have to support then.
Thanks for the help!
Jennifer