The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
IC Error - SLXGetDate (SLX 7.2.2)
Posted: 08 Aug 08 12:54 AM
|
I am getting an error running the SLX Integrity Checker:
ERROR: 'SLXGETDATE' is not a recognized built-in function name
It occurs as a result of the Marketing - Purge HIST_LEAD test:
=== List SQL =========================
SELECT HIST_LEADID
FROM HIST_LEAD_ADDRESS
WHERE NOT EXISTS(SELECT HIST_LEADID FROM HIST_LEAD
WHERE HIST_LEAD.HIST_LEADID = HIST_LEAD_ADDRESS.HIST_LEADID)
=== Repair SQL =========================
DELETE
FROM HIST_LEAD_ADDRESS
WHERE NOT EXISTS(SELECT HIST_LEADID FROM HIST_LEAD
WHERE HIST_LEAD.HIST_LEADID = HIST_LEAD_ADDRESS.HIST_LEADID)
Does anyone have a clue why?
Interestingly, SLXGetDate returns zero results when Googled!
Thanks for any input
Phil |
|
|
|
Re: IC Error - SLXGetDate (SLX 7.2.2)
Posted: 09 Aug 08 3:52 AM
|
I believe you mean this one:
=== List SQL =========================
SELECT HIST_LEADID, CREATEDATE
FROM HIST_LEAD
WHERE SLXDATEDIFF(dd, CREATEDATE, SLXGETDATE(GMT)) > 30
=== Repair SQL =========================
DELETE
FROM HIST_LEAD
WHERE SLXDATEDIFF(dd, CREATEDATE, SLXGETDATE(GMT)) >
You can workaround this by replacing SLXGetDate with GetDate() or GetUTCDate() instead (i.e. use SQL instead of SLX function).
Is it possible this is not a 7.2.2 system/exe (slxdbchecker.exe)? I ask because I ran that test and it works fine - but I have seen it fail in 7.0.1. Also, what yo uneed to check is the following tables:
SLXOLEDBPLUGIN
SLXOLEDBPLUGINDATA
SLXSQLDEFAULT
SLXSQLSCALARFN
And compare them with a 7.2.2 eval database - as I think you're missing a few entries and updates.
|
|
|
|
Re: IC Error - SLXGetDate (SLX 7.2.2)
Posted: 09 Aug 08 8:42 AM
|
As Mike pointed out.. these were added to the "Provider Plugin(s)". They are there so that the provider can do the right thing with both SQL Server and Oracle. Getdate is a SQL server thing.. and not in Oracle 
SO you need to make sure you ran in the bundle updates as well. |
|
|
|
Re: IC Error - SLXGetDate (SLX 7.2.2)
Posted: 19 Aug 08 7:13 PM
|
Thank you Bob and Mike - I repopulated the suggested tables from the Eval db and all now runs fine.
I had been over zealous with a db clean-up script and had neglected to omit these tables from the DELETE ...
Thanks again.
Phil |
|
|
|