| |
Results |
|
DIM10: Report Builder error - Ora-01830: Date format picture ends before converting entire input string
|
DBIO error SQL 1830 - Ora-01830: Date format picture ends before converting entire input string
|
|
|
|
Problem with Content | Search | by date on non-English MS/SQL
|
D.FileDate BETWEEN '2006-11-01 00:00:00' AND '2006-12-02 00:00:00' So, Collage is trying to use "2006-11-01" as a date format . While this seems to work on English servers, it does NOT work on others.
|
|
|
|
KM-Dim7: PDIFF returns error when used with Dump Change Documents: 1019-DBIO: ORACLE Error occurred SQL-0438(4120) ORA-01841: (full) year must be between -4713 and 9999, and not be 0
|
1. Check the the init<sid>.ora for the value of the variable NLS_ DATE _ FORMAT and make sure it's set correctly (the value of the variable should be set as nls_ date _ format = DD-MON-YYYY)
|
|
|
|
Dim10: DBC:-9999-Unrecognised to_date() variant - unsupported format with null occurs during Upload, Create Item or Checkin
|
When trying to perform an upload, create item, or checkin when using a Solaris Agent (10.1.3) to a Windows Server (10.1.3) with SQL Server 2000 and the files are over 2MB, the following error occurs: Creating new item revision for '<remotenode>::/home/dmsys/Test/Test_Load_Results.log' DBC:-9999-Unrecognised to_date() variant - unsupported format with null
|
|
|
|
DIM10: Report error in desktop client using a Date attribute
|
DBI0004527E: DBIO: Database I/O error occurred SQL -1830(02ADD2B8) ORA-1830: date format picture ends before converting entire output string" If you logout and login again to Desktop Client the final Oracle error is not generated if you attempt to rerun the report.
|
|
|
|
SBM: How to read the value of a date/time column from the database
|
SQL Format : DATEADD(s,COLUMN_NAME, '1970-01-01') -- OR --
|
|
|
|
Dim CM 2009 R2: Sorting user-defined columns in desktop client reports ORA-01861
|
If user-defined attributes are shown as columns in the desktop client, and there are different types ( date , number, character) of attribute with the same attribute number in the database, this can cause the error: SQL -1861(022F8D58) ORA-01861: literal does not match format string, when trying to sort the display using these columns.
|
|
|
Serena Collage Installation and Setup Guide
|
adding supported servers 91 editing settings for 97 Microsoft SQL , preparing to use with Collage 29 moving projects to 103 Oracle, preparing to use with Collage 26 database servers adding 91 Admin database 23 associating with system groups 101 deleting 102 editing 97 IP and port 133 databases see also Admin database date formats , international 12 DavEnable 120 DB security, choosing 124 default installation directory Collage 35 Ghostscript 63 default password Admin database ... service 58 on Windows 58 deploy cache 135 deployment with SOCKS authentication 124 directory, default installation 35 drivers, Microsoft SQL 30
|
|
|
|
Serena Collage Installation and Setup Guide
|
Danish date formats 12 database owner name, storing default 94 database platforms adding supported servers 90 editing settings for 95 Microsoft SQL , preparing to use with Collage 29 moving projects to 102 Oracle, preparing to use with Collage 26 database servers adding 90 Admin database 22 associating with system groups 100 deleting 100 editing 95 IP and port 131 databases see also Admin database date formats , international 12 DavEnable 120 DB security, choosing 123 default installation directory Collage 35 Ghostscript 61 default password Admin database 127 project databases 131 default port number Collage 24 Deploy ...
|
|
|
|
Serena Collage Installation and Setup Guide
|
adding supported servers 90 editing settings for 95 Microsoft SQL , preparing to use with Collage 29 moving projects to 102 Oracle, preparing to use with Collage 26 database servers adding 90 Admin database 22 associating with system groups 100 deleting 100 editing 95 IP and port 131 databases see also Admin database date formats , international 12 DavEnable 120 DB security, choosing 123 default installation directory Collage 35 Ghostscript 61 default password Admin database ... service 56 on Windows 56 deploy cache 133 deployment with SOCKS authentication 122 directory, default installation 35 drivers, Microsoft SQL 30
|
|
|
