Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC error 8114 on setting duration field into 1 minute

Highlighted

JDBC error 8114 on setting duration field into 1 minute

Hello, im getting error below then tryin to set duration custom field in 1 minute. Then i set it in 2 min or more everything going normal.
HPSD45 SP29, MSSQL 2000. Any ideas?

JDBC error 8114: [SKZHAP18]Error converting data type nvarchar to float., SQL state: 01000 for query: UPDATE itsm_ser_cft001
SET A1$_DELTA= ?
WHERE (((ITSM_SER_CFT001_oid = ?)))
Values:
?0,0006944444
(((ITSM_SER_CFT001_oid = ?)))
14 REPLIES

Re: JDBC error 8114 on setting duration field into 1 minute

up, any ideas anybody?
Alexander Kriku
Frequent Visitor

Re: JDBC error 8114 on setting duration field into 1 minute


hi

an assumption:
1 minute = 1/(24*60) = 0,000694
2 minutes = 2/(24*60) = 0,00138

the difference is in one degree
maybe SD convert process doesn't work with float that is less than e-3

Re: JDBC error 8114 on setting duration field into 1 minute

Anybody can test that case on sp29? (Set dur. 1min to any duration field in SC and check log for sql errors)
Jancas
Occasional Contributor

Re: JDBC error 8114 on setting duration field into 1 minute

I have the same problem with SP29.
I allready opened a case in HP support.

I don't know why but if the actual start and the actual finish have a 2 minutes diference there is no problem. If they are the same i get this error.

As soon as i get the solution, i'll tell.

Regards
Jaime

Re: JDBC error 8114 on setting duration field into 1 minute

Thanks for reply and case.
Hope to hear soon.
Igor

Re: JDBC error 8114 on setting duration field into 1 minute

Up. Any news about this case anybody?

Re: JDBC error 8114 on setting duration field into 1 minute

Jaime, which SQL Server version do u use?
Dmitry Utkin
Super Collector

Re: JDBC error 8114 on setting duration field into 1 minute

UP
I have the same problem after upgrade to sp29.
Is there are any news ?
Michal Kovac
Frequent Visitor

Re: JDBC error 8114 on setting duration field into 1 minute

Same in SP30 (tested with several JREs 1.5.x-1.6.0_14, RDBMS used: MS SQL 2000 SP4).
Err_1
Honored Contributor

Re: JDBC error 8114 on setting duration field into 1 minute

Hi,

There is a known error about this.

http://support.openview.hp.com/selfsolve/document/KM725415

Regards;
Randall Barrantes
SW Support Delivery Manager
Denis_35
Collector

Re: JDBC error 8114 on setting duration field into 1 minute

Where i can get sp31?

Re: JDBC error 8114 on setting duration field into 1 minute

on support.openview.hp.com
but SP31 is not yet avaialable

ETA anybody?
The Pike
Honored Contributor

Re: JDBC error 8114 on setting duration field into 1 minute

Since the Service Desk EOL was announced
the trend in Service Pack releases has been every 2-4 months.

SP30 was released in April.

The Pike

Denis_35
Collector

Re: JDBC error 8114 on setting duration field into 1 minute

//Add this to "OnDomLoad" event