Data Access Error at the CHeck Fish level in FDM 11.1.2.2
edited Nov 8, 2013 2:47AM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 5 commentsAnswered ✓
This is the error from fdm
** Begin FDM Runtime Error Log Entry [2013-11-06 18:28:01] **
-------------------------------------------------------------
ERROR:
Code............................................. -2147217900
Description...................................... 'TO_CHAR' is not a recognized built-in function name.
SELECT
CatKey,
PeriodKey,
rptEntityStatus,
rptLocation,
rptName,
rptDesc,
rptMode,
rptTitle,
rptSubTitle,
rptEntName,
rptEntCat,
rptEntPer,
rptRuleSeq,
rptRuleTitle,
rptRuleDef,
rptAcct,
rptAcctDesc,
rptAcctVal,
rptTime,
rptRuleStatus,
UDVal1,
UDVal2,
UDText1,
UDText2,
UDText3
FROM tDataCheck
WHERE
(CatKey = 12)
AND (TO_CHAR(PeriodKey, N'YYYYMMDD') = N'20121231')
AND (PartitionKey = 774)
ORDER BY rptEntName, rptRuleSeq
Procedure........................................ clsDataAccess.farsSnap
Component........................................ upsWDataWindowDM
Version.......................................... 1112
Thread........................................... 4060
IDENTIFICATION:
User............................................. lordalain
Computer Name.................................... AURMS11DHFM01
App Name......................................... FTEST
Client App....................................... WebClient
CONNECTION:
Provider......................................... SQLOLEDB
Data Server...................................... aurmssqldcls2.magna.global\instance2
0