Foxhound 5.0 FAQ
search engine by freefind advanced
Foxhound 5.0 FAQ Home      Foxhound Home      RisingRoad           Breck.Carter@gmail.com     


Message: 532a call location ... Info: BIGINT property value "...' out of range ... to ...
Message: 532b call location ... Info: DECIMAL property value "...' out of range ... to ...
Message: 532c call location ... Info: UNSIGNED BIGINT property value "...' out of range ... to ...
Message: BIGINT property value "...' out of range ... to ...
Message: DECIMAL property value "...' out of range ... to ...
Message: Info: ... property value "...' out of range ... to ...
Message: UNSIGNED BIGINT property value "...' out of range ... to ...

Explanation: Each time an input SQL Anywhere property value is modified because it is out of range, an information diagnostic message is recorded to show the original value.

This is done for the first 500 out of range values encountered during one connection to the target database. After that, the values are still modified but messages are not recorded to avoid message storms. To start recording messages again, stop and start sampling for that target database.

These messages are not expected, so if they are causing you any grief, please contact breck.carter@gmail.com.

Here's what the messages look like in Foxhound Options - Diagnostics:

17  2020-04-25 15:41:36.227 Full Build 5439a 1000001318 532a call location 12 
       Info: BIGINT property value "10000000000000001" out of range 0 to 10000000000000000 [2-ddd17]

31  2020-04-25 15:41:36.235 Full Build 5439a 1000001318 532c call location 29 
       Info: UNSIGNED BIGINT property value "18446744073709551616" out of range 0 to 18446744073709551615 [2-ddd17]

41  2020-04-25 15:41:36.238 Full Build 5439a 1000001318 532b call location 46 
       Info: DECIMAL property value "10000000000000001" out of range 0.000000 to 10000000000000000.000000 [2-ddd17]

The call location ... numbers (12, 29 and 46 in the example above) can be used to find the SQL Anywhere CONNECTION_PROPERTY, DB_PROPERTY and PROPERTY names in the table below.

Note that these call location numbers have no significance outside the Info messages; they are specific to Foxhound:

 Info
 Call     SQL Anywhere         SQL Anywhere    
Location  Property Type        Property Name
======== ===================  =================== 
   1     CONNECTION_PROPERTY  ApproximateCPUTime 
   2     CONNECTION_PROPERTY  BlockedOn 
   3     CONNECTION_PROPERTY  BytesReceived
   4     CONNECTION_PROPERTY  BytesSent
   5     CONNECTION_PROPERTY  CacheHits
   6     CONNECTION_PROPERTY  CacheRead
   7     CONNECTION_PROPERTY  CacheReadIndInt
   8     CONNECTION_PROPERTY  CacheReadIndLeaf 
   9     CONNECTION_PROPERTY  CacheReadTable 
   10    CONNECTION_PROPERTY  ClientStmtCacheHits
   11    CONNECTION_PROPERTY  ClientStmtCacheMisses
   12    CONNECTION_PROPERTY  Commit
   13    CONNECTION_PROPERTY  CurrentLineNumber
   14    CONNECTION_PROPERTY  DiskRead
   15    CONNECTION_PROPERTY  DiskReadIndInt
   16    CONNECTION_PROPERTY  DiskReadIndLeaf
   17    CONNECTION_PROPERTY  DiskReadTable
   18    CONNECTION_PROPERTY  DiskWrite
   19    CONNECTION_PROPERTY  FullCompare 
   20    CONNECTION_PROPERTY  IndAdd 
   21    CONNECTION_PROPERTY  IndLookup 
   24    CONNECTION_PROPERTY  CONNECTION_PROPERTY  LockCount
   25    CONNECTION_PROPERTY  LockName
   26    CONNECTION_PROPERTY  LockObjectOID
   27    CONNECTION_PROPERTY  LockObjectType
   28    CONNECTION_PROPERTY  LockRowID
   29    CONNECTION_PROPERTY  LockTableOID
   35    CONNECTION_PROPERTY  LogWrite 
   36    CONNECTION_PROPERTY  max_client_statements_cached 
   37    CONNECTION_PROPERTY  Max_plans_cached 
   38    CONNECTION_PROPERTY  max_query_tasks 
   39    CONNECTION_PROPERTY  Prepares 
   40    CONNECTION_PROPERTY  PrepStmt 
   41    CONNECTION_PROPERTY  QueryHeapPages 
   42    CONNECTION_PROPERTY  QueryLowMemoryStrategy
   43    CONNECTION_PROPERTY  QueryOptimized
   44    CONNECTION_PROPERTY  QueryReused
   45    CONNECTION_PROPERTY  ReqCountActive 
   46    CONNECTION_PROPERTY  ReqTimeActive   
   47    CONNECTION_PROPERTY  ReqTimeBlockContention   
   48    CONNECTION_PROPERTY  ReqTimeBlockIO   
   49    CONNECTION_PROPERTY  ReqTimeBlockLock   
   50    CONNECTION_PROPERTY  ReqTimeUnscheduled   
   51    CONNECTION_PROPERTY  RequestsReceived
   52    CONNECTION_PROPERTY  Rlbk
   53    CONNECTION_PROPERTY  RollbackLogPages
   54    CONNECTION_PROPERTY  TempFilePages 
   55    CONNECTION_PROPERTY  UncommitOp
   56    PROPERTY             ActiveReq               
   57    DB_PROPERTY          BytesReceived           
   58    PROPERTY             BytesReceived            
   59    DB_PROPERTY          BytesSent               
   60    PROPERTY             BytesSent                
   61    PROPERTY             CacheHits                
   62    DB_PROPERTY          CacheHits               
   63    PROPERTY             CachePanics             
   64    PROPERTY             CacheRead                 
   65    DB_PROPERTY          CacheRead               
   66    DB_PROPERTY          CacheReadIndInt                               
   67    DB_PROPERTY          CacheReadIndLeaf                                
   68    DB_PROPERTY          CacheReadTable                              
   69    DB_PROPERTY          CheckpointLogSize                          
   70    DB_PROPERTY          CheckpointUrgency       
   71    PROPERTY             Chkpt                    
   72    DB_PROPERTY          Chkpt                   
   73    DB_PROPERTY          Commit                          
   74    DB_PROPERTY          ConnCount               
   75    PROPERTY             CurrentCacheSize        
   76    PROPERTY             CurrIO                  
   77    DB_PROPERTY          CurrIO                  
   78    DB_PROPERTY          CurrRead                
   79    DB_PROPERTY          CurrWrite               
   80    DB_PROPERTY          DBFileFragments         
   81    PROPERTY             DiskRead                  
   82    DB_PROPERTY          DiskRead                
   83    DB_PROPERTY          DiskReadIndInt                                    
   84    DB_PROPERTY          DiskReadIndLeaf                                   
   85    DB_PROPERTY          DiskReadTable                                   
   86    PROPERTY             DiskWrite                 
   87    DB_PROPERTY          DiskWrite               
   88    DB_PROPERTY          FileSize                
   89    DB_PROPERTY          FreePages                
   90    PROPERTY             FullCompare               
   91    DB_PROPERTY          FullCompare             
   92    DB_PROPERTY          GlobalDBId                                     
   93    PROPERTY             IndAdd                    
   94    DB_PROPERTY          IndAdd                  
   95    PROPERTY             IndLookup                 
   96    DB_PROPERTY          IndLookup               
   97    DB_PROPERTY          LockCount               
   98    PROPERTY             LogWrite                  
   99    DB_PROPERTY          LogWrite                
   100   PROPERTY             MaxCacheSize             
   101   PROPERTY             MultiProgrammingLevel    
   102   PROPERTY             Threads                 
   103   PROPERTY             NumLogicalProcessorsUsed 
   104   PROPERTY             NumProcessorsMax         
   105   PROPERTY             NumProcessorsAvail      
   106   PROPERTY             ProcessCPU              
   107   DB_PROPERTY          QueryLowMemoryStrategy   
   108   DB_PROPERTY          RecoveryUrgency         
   109   PROPERTY             Req                      
   110   PROPERTY             UnschReq                
   111   DB_PROPERTY          LogFileFragments         
   112   DB_PROPERTY          logFileSize             
   113   DB_PROPERTY          logFreePages            
   114   DB_PROPERTY          tempFileFragments       
   115   DB_PROPERTY          tempFileSize             
   116   DB_PROPERTY          tempFreePages           
   117   DB_PROPERTY          ConnCount         
   118   PROPERTY             NumPhysicalProcessorsUsed      
   119   CONNECTION_PROPERTY  ParentConnection
   200   CONNECTION_PROPERTY  BlockedOn
   201   CONNECTION_PROPERTY  BytesReceived
   202   CONNECTION_PROPERTY  BytesSent
   203   CONNECTION_PROPERTY  CacheHits
   204   CONNECTION_PROPERTY  CacheRead
   205   CONNECTION_PROPERTY  CacheReadIndInt
   206   CONNECTION_PROPERTY  CacheReadIndLeaf
   207   CONNECTION_PROPERTY  CacheReadTable
   208   CONNECTION_PROPERTY  ClientStmtCacheHits
   209   CONNECTION_PROPERTY  ClientStmtCacheMisses
   210   CONNECTION_PROPERTY  Commit
   211   CONNECTION_PROPERTY  CurrentLineNumber
   212   CONNECTION_PROPERTY  DiskRead
   213   CONNECTION_PROPERTY  DiskReadIndInt
   214   CONNECTION_PROPERTY  DiskReadIndLeaf
   215   CONNECTION_PROPERTY  DiskReadTable
   216   CONNECTION_PROPERTY  DiskWrite
   217   CONNECTION_PROPERTY  FullCompare
   218   CONNECTION_PROPERTY  IndAdd
   219   CONNECTION_PROPERTY  IndLookup
   220   CONNECTION_PROPERTY  LastPlanText_id
   221   CONNECTION_PROPERTY  LastStatement_id
   222   CONNECTION_PROPERTY  LockCount
   228   CONNECTION_PROPERTY  LogWrite
   229   CONNECTION_PROPERTY  max_client_statements_cached
   220   CONNECTION_PROPERTY  Max_plans_cached
   221   CONNECTION_PROPERTY  max_query_tasks
   232   CONNECTION_PROPERTY  Prepares
   233   CONNECTION_PROPERTY  PrepStmt
   234   CONNECTION_PROPERTY  QueryHeapPages
   235   CONNECTION_PROPERTY  QueryLowMemoryStrategy
   236   CONNECTION_PROPERTY  QueryOptimized
   237   CONNECTION_PROPERTY  QueryReused
   238   CONNECTION_PROPERTY  ReqCountActive
   239   CONNECTION_PROPERTY  RequestsReceived
   240   CONNECTION_PROPERTY  Rlbk
   241   CONNECTION_PROPERTY  RollbackLogPages
   242   CONNECTION_PROPERTY  TempFilePages
   243   CONNECTION_PROPERTY  UncommitOp
   244   CONNECTION_PROPERTY  ParentConnection
   300   CONNECTION_PROPERTY  ApproximateCPUTime
   301   CONNECTION_PROPERTY  ReqTimeActive
   302   CONNECTION_PROPERTY  ReqTimeBlockContention
   303   CONNECTION_PROPERTY  ReqTimeBlockIO
   304   CONNECTION_PROPERTY  ReqTimeBlockLock
   305   CONNECTION_PROPERTY  ReqTimeUnscheduled
   400   CONNECTION_PROPERTY  LockName
   401   CONNECTION_PROPERTY  LockObjectOID
   402   CONNECTION_PROPERTY  LockObjectType
   403   CONNECTION_PROPERTY  LockRowID
   404   CONNECTION_PROPERTY  LockTableOID


This page was last updated on May 7, 2020.      Foxhound 5.0 FAQ Home      Foxhound Home      RisingRoad      Breck.Carter@gmail.com