[itsm] General catalog and ConfigItem Classes

Gustavo Dias Silveira gustavo at ilegra.com
Fri Feb 1 09:42:15 GMT 2008


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 at 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 at 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 at 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 at otrs.org [mailto:itsm-bounces at 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 at mundivia.net
    Telf. 942 355 931
 http://www.mundivia.net
-----Mensaje original-----
De: itsm-bounces at otrs.org [mailto:itsm-bounces at 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 at otrs.org [mailto:itsm-bounces at 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 at 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
 



More information about the itsm mailing list