AnsweredAssumed Answered

SUGARCRM - NLS data files Conversion of date error

Question asked by Craig Burtenshaw on Jan 6, 2015
Latest reply on Apr 13, 2015 by SimonEarl SimonEarl
Hi experts,

I am connecting a SugarCRM (Version 6.5.17 (Build 1220)) environment to an Oracle database (11.2.0.3.0)

The users are confronted with this error when changing screens.  Even as the Admin user.
Database failure. Please refer to sugarcrm.log for details.

Reviewing the sugarcrm.log file I see these messages repeated ...
06.01.2015 15.56.01 [797][-none-][FATAL]  Query Failed: alter session set                nls_date_format = 'YYYY-MM-DD hh24:mi:ss'
                QUERY_REWRITE_INTEGRITY = TRUSTED
                QUERY_REWRITE_ENABLED = TRUE
                NLS_LENGTH_SEMANTICS=CHAR
                NLS_COMP=LINGUISTIC
                                NLS_SORT=utf8_general_ci: 12705-ORA-12705: Cannot access NLS data files or invalid environment specified
06.01.2015 15.56.02 [797][1][ERROR] convert: Conversion of 24-DEC-14 00:00:00 from Y-m-d H:i:s to d.m.Y H:i failed
06.01.2015 15.56.02 [797][1][ERROR] convert: Conversion of 24-DEC-14 00:00:00 from Y-m-d H:i:s to d.m.Y H:i failed
06.01.2015 15.56.02 [797][1][ERROR] convert: Conversion of 24-DEC-14 00:00:00 from Y-m-d H:i:s to d.m.Y H:i failed
06.01.2015 15.56.02 [797][1][ERROR] convert: Conversion of 24-DEC-14 00:00:00 from Y-m-d H:i:s to d.m.Y H:i failed
06.01.2015 15.56.02 [797][1][ERROR] convert: Conversion of 24-DEC-14 00:00:00 from Y-m-d H:i:s to d.m.Y H:i failed
06.01.2015 15.56.02 [797][1][ERROR] convert: Conversion of 24-DEC-14 00:00:00 from Y-m-d H:i:s to d.m.Y H:i failed
06.01.2015 15.56.02 [797][1][ERROR] convert: Conversion of 24-DEC-14 00:00:00 from Y-m-d H:i:s to d.m.Y H:i failed
06.01.2015 15.56.02 [797][1][ERROR] convert: Conversion of 24-DEC-14 00:00:00 from Y-m-d H:i:s to d.m.Y H:i failed
06.01.2015 15.57.01 [805][-none-][FATAL]  Query Failed: alter session set
                nls_date_format = 'YYYY-MM-DD hh24:mi:ss'
                QUERY_REWRITE_INTEGRITY = TRUSTED
                QUERY_REWRITE_ENABLED = TRUE
                NLS_LENGTH_SEMANTICS=CHAR
                NLS_COMP=LINGUISTIC
                                NLS_SORT=utf8_general_ci: 12705-ORA-12705: Cannot access NLS data files or invalid environment specified
06.01.2015 15.57.01 [805][1][ERROR] convert: Conversion of 24-DEC-14 00:00:00 from Y-m-d H:i:s to d.m.Y H:i failed
06.01.2015 15.57.01 [805][1][ERROR] convert: Conversion of 24-DEC-14 00:00:00 from Y-m-d H:i:s to d.m.Y H:i failed
06.01.2015 15.57.01 [805][1][ERROR] convert: Conversion of 24-DEC-14 00:00:00 from Y-m-d H:i:s to d.m.Y H:i failed
06.01.2015 15.57.01 [805][1][ERROR] convert: Conversion of 24-DEC-14 00:00:00 from Y-m-d H:i:s to d.m.Y H:i failed
06.01.2015 15.57.01 [805][1][ERROR] convert: Conversion of 24-DEC-14 00:00:00 from Y-m-d H:i:s to d.m.Y H:i failed
06.01.2015 15.57.01 [805][1][ERROR] convert: Conversion of 24-DEC-14 00:00:00 from Y-m-d H:i:s to d.m.Y H:i failed
06.01.2015 15.57.01 [805][1][ERROR] convert: Conversion of 24-DEC-14 00:00:00 from Y-m-d H:i:s to d.m.Y H:i failed
06.01.2015 15.57.01 [805][1][ERROR] convert: Conversion of 24-DEC-14 00:00:00 from Y-m-d H:i:s to d.m.Y H:i failed

Google was unable to help - I'm hoping that someone here has seen this before and point me in the right direction.

Thank you in advance.
Craig.

Outcomes