In Your Config.pm file you can put these environment configurations: $ENV{'ORACLE_HOME'} = '/app/oracle/product/10.1.0'; $ENV{'NLS_DATE_FORMAT'} = 'yyyy-mm-dd hh24:mi:ss'; $ENV{NLS_LANG} = "american_america.we8iso8859p1"; Regards ilegra immediate Gustavo Dias Silveira Equipe Infra-estrutura – Oracle DBA Certified Professional (OCP) ITIL (IT Infrastructure Library) Foundation gustavo@ilegra.com fone : 55 51 3212 8444 - 55 51 9196 6632 rua washington luiz, 820 cj. 902 centro | poa rs | brasil | cep: 90010-460 www.ilegra.com -----Original Message----- From: Gustavo Dias Silveira [mailto:gustavo@ilegra.com] Sent: Wednesday, January 30, 2008 5:19 PM To: 'OTRS::ITSM User questions and discussions' Subject: RE: [itsm] General catalog and ConfigItem Classes In Your Config.pm file you can put these environment configurations: $ENV{'ORACLE_HOME'} = '/app/oracle/product/10.1.0'; $ENV{'NLS_DATE_FORMAT'} = 'yyyy-mm-dd hh24:mi:ss'; $ENV{NLS_LANG} = "american_america.we8iso8859p1"; Regards ilegra immediate Gustavo Dias Silveira Equipe Infra-estrutura – Oracle DBA Certified Professional (OCP) ITIL (IT Infrastructure Library) Foundation gustavo@ilegra.com fone : 55 51 3212 8444 - 55 51 9196 6632 rua washington luiz, 820 cj. 902 centro | poa rs | brasil | cep: 90010-460 www.ilegra.com -----Original Message----- From: itsm-bounces@otrs.org [mailto:itsm-bounces@otrs.org] On Behalf Of DAVID SALGADO VIDAL Sent: Wednesday, January 30, 2008 4:55 PM To: OTRS::ITSM User questions and discussions Subject: RE: [itsm] General catalog and ConfigItem Classes I've looked my log, and when OTRS's install module tries to insert records into the tables, it doesn't work and report this error. Jan 29 10:05:56 servotrs01 OTRS-CGI-10[11019]: [Error][Kernel::System::Package::PackageInstall][Line:601]: ORA-01861: el literal no coincide con la cadena de formato (DBD ERROR: error possibly near <*> indicator at char 166 in 'INSERT INTO general_catalog (general_catalog_class, name, valid_id, create_time, create_by, ch ange_time, change_by) VALUES ('ITSM::Core::Impact', '2 low', 1, <*>'2008-01-29 10:05:56', 1, '2008-01-29 10:05:56', 1)'), SQL: 'INSERT INTO general_catalog (general_catalog_class, name, valid_id, create_time, create_by, change_time, change_by) VALUES ('ITSM::Core::Impact', '2 low', 1, '2008-01-29 10:05:56', 1, '2008-01-29 10:05:56', 1)' I´ve found that this error happen when the SQL sentence doesn't use the TO_DATE() function and try to insert a string into a date field. A solution is to use the function and another set the NLS_DATE_FORMAT session variable. But, can I do OTRS install module use it? How? Thanks. Best Regards. David Salgado Vidal david.salgado@mundivia.net Telf. 942 355 931 http://www.mundivia.net -----Mensaje original----- De: itsm-bounces@otrs.org [mailto:itsm-bounces@otrs.org] En nombre de Manuel Hecht - OTRS AG Enviado el: lunes, 07 de enero de 2008 11:18 Para: 'OTRS::ITSM User questions and discussions' Asunto: AW: [itsm] General catalog and ConfigItem Classes Hi David That's not normal! Please have a look at your OTRS log and your database log to find the cause of the problem. Best regards, Manuel Hecht ((otrs)) :: OTRS AG :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0)9421 56818 0 :: Fax: +49 (0)9421 56818 18 http://www.otrs.com/ :: Communication with success! -----Ursprüngliche Nachricht----- Von: itsm-bounces@otrs.org [mailto:itsm-bounces@otrs.org] Im Auftrag von DAVID SALGADO VIDAL Gesendet: Mittwoch, 2. Januar 2008 20:32 An: OTRS::ITSM User questions and discussions Betreff: [itsm] General catalog and ConfigItem Classes Hi. I've installed otrs ITSM 1.0.4 modules without errors, but I haven't any Catalog Class and any ConfigItem Class. It is normal? I remember that it does not happen in previous versions, those I tried. Could be? My installation is Linux Red Hat ES 4 with Oracle 10 client, and my database is Oracle 9i. Thank you. Best regards. David Salgado Vidal david.salgado@mundivia.net Telf. 942 355 931 http://www.mundivia.net ------------------------------------------------------------------ This e-mail and the documents attached are confidential and intended solely for the addressee; it may also be privileged. If you receive this e-mail in error, please notify the sender immediately and destroy it. As its integrity cannot be secured on the Internet, the Atos Origin group liability cannot be triggered for the message content. Although the sender endeavours to maintain a computer virus-free network, the sender does not warrant that this transmission is virus-free and will not be liable for any damages resulting from any virus transmitted. Este mensaje y los ficheros adjuntos pueden contener informacion confidencial destinada solamente a la(s) persona(s) mencionadas anteriormente. Pueden estar protegidos por secreto profesional Si usted recibe este correo electronico por error, gracias de informar inmediatamente al remitente y destruir el mensaje. Al no estar asegurada la integridad de este mensaje sobre la red, Atos Origin no se hace responsable por su contenido. Su contenido no constituye ningun compromiso para el grupo Atos Origin, salvo ratificacion escrita por ambas partes. Aunque se esfuerza al maximo por mantener su red libre de virus, el emisor no puede garantizar nada al respecto y no sera responsable de cualesquiera danos que puedan resultar de una transmision de virus ------------------------------------------------------------------ _______________________________________________ OTRS mailing list: itsm - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/itsm To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm Support or consulting for your OTRS::ITSM system? => http://www.otrs.com/ _______________________________________________ OTRS mailing list: itsm - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/itsm To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm Support or consulting for your OTRS::ITSM system? =http://www.otrs.com/ ------------------------------------------------------------------ This e-mail and the documents attached are confidential and intended solely for the addressee; it may also be privileged. If you receive this e-mail in error, please notify the sender immediately and destroy it. As its integrity cannot be secured on the Internet, the Atos Origin group liability cannot be triggered for the message content. Although the sender endeavours to maintain a computer virus-free network, the sender does not warrant that this transmission is virus-free and will not be liable for any damages resulting from any virus transmitted. Este mensaje y los ficheros adjuntos pueden contener informacion confidencial destinada solamente a la(s) persona(s) mencionadas anteriormente. Pueden estar protegidos por secreto profesional Si usted recibe este correo electronico por error, gracias de informar inmediatamente al remitente y destruir el mensaje. Al no estar asegurada la integridad de este mensaje sobre la red, Atos Origin no se hace responsable por su contenido. Su contenido no constituye ningun compromiso para el grupo Atos Origin, salvo ratificacion escrita por ambas partes. Aunque se esfuerza al maximo por mantener su red libre de virus, el emisor no puede garantizar nada al respecto y no sera responsable de cualesquiera danos que puedan resultar de una transmision de virus ------------------------------------------------------------------ _______________________________________________ OTRS mailing list: itsm - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/itsm To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm Support or consulting for your OTRS::ITSM system? =http://www.otrs.com/ No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.19.16/1251 - Release Date: 1/30/2008 9:29 AM No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.19.16/1251 - Release Date: 1/30/2008 9:29 AM No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.19.16/1251 - Release Date: 1/30/2008 9:29 AM