Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Increase bScale in DBPARAMBINDINFO Error in PB 12.1 Ver 7000

Hello.  Can't seem to get around the below error in PB 12.1 Ver 7000 when calling a Stored Procedure from Powerscript and am passing Datetime values.  I have played around with the connection strings Date formatting, but no matter what I attempt, it still looks like the PB is passing MM/DD/YYYY HH:MM:SS when SQL Server 2012 is expectring YYYY-MM-DD HH:MM:SS.

Full error:

SQLSTATE = 22007

Microsoft SQL Server Native Client 11.0

The fractional part of the provided time value overflows the scale of the corresponding SQL Server parameter or column. Increase bScale in DBPARAMBINDINFO or column scale to correct this error.

I've tried to use providers of SQLOLEDB, SQLNCLI10 & SQLNCLI11

Connection Profile String (Connection works fine):

// Profile for SIngle Sign On....


SQLCA.Lock = "RU"

SQLCA.AutoCommit = False


In the above, I have also tried to specify the following, whcih also works, but the same result (notice the date parameters match what SQL Server should expect for Datetime data types...

// Profile


SQLCA.LogPass = <**************>


SQLCA.Lock = "RU"

SQLCA.AutoCommit = False

SQLCA.DBParm = "PROVIDER='SQLOLEDB',DATASOURCE='DB-DNS-ENTRY',PROVIDERSTRING='Database=DB-NAME',DateFormat='yyyy-mm-dd',DateTimeFormat='yyyy-mm-dd hh:mm:ss.fff',TimeFormat='hh:mm:ss.fff'"

Not what you were looking for? View more on this topic or Ask a question