Problem With Rowcount while trying to bulk insert

[naresh561]

I have a sp

ALTER PROCEDURE [dbo].[sp_select_Test2] @Test [dbo].[TestTableType] READONLY 
AS
    BEGIN
        INSERT INTO dbo.test
        (
            Code,
            Text,
            Type
        ) 
        SELECT Name,
               Name,
               ID
        FROM   @Test		
    END;

I have this code

def executeSP(self, SPName, params=[]):
      with pytds.connect(self.server, self.dbname, self.user, self.dbpwd) as connection:
          connection.autocommit = True
          # Check how to create Secure query
          with connection.cursor() as cursor:
              try:
                  cursor.callproc(SPName, params)
                  rows = None
                  if(cursor.rowcount < 0):
                      rows = cursor.fetchall()
                  cursor.close()
                  return rows

              except Exception as e:
                  if(self.logger):
                      self.logger.error(
                          "error executeQuery {0}, {1}".format(SPName, e))
                  else:
                      print(e)

dbObj = DBWrapper(DB_NAME, DB_PASSWORD, DB_USERNAME, DB_SERVER)
ipData = [ ["abc", 1],["def", 2],["ghi", 3]]

The Problem occurs when I am trying to call the SP with following code

ipTvp = dbObj.makeTVP('dbo.TestTableType', ipData)
data = dbObj.executeSP('dbo.sp_select_Test2', [ipTvp])

the RowCount is -1 while it should be non negative value. Please help Me, Thank you.

[naresh561]

I found that in tds.py Line number 707

if done_count_valid:
            self.rows_affected = rows_affected
        else:
            self.rows_affected = -1

is causing the issue

[takoau]

@naresh561 For your reference: MS-TDS: DONEPROC

The DONE_COUNT flag in DONEPROC message is 0, simply states that bulk insert does not returns a row count, so it's natural to have -1 as return value. 0x10: DONE_COUNT. The DoneRowCount value is valid. This is used to distinguish between a valid value of 0 for DoneRowCount or just an initialized variable.