The language expression property array index '1' is out of bounds..

[Karima519811]

Hello,
i have modules that i create that i call to create ressources for project and it was working fine, i added the module SQL server with DBs ad i receive an error linked to error in deployment template

Error:
InvalidTemplate - Deployment template validation failed: 'The template resource 'sql-testDB-DEV' at line '1' and column '1492' is not valid: The language expression property array index '1' is out of bounds.. Please see https://aka.ms/arm-functions for usage details.'.
The error doesn't seems clear in wich part i have the issue cause i try to create only the sql server and i receive the same issue i don't think it's linked to the code.

main.bicep (that call the modules):

/////////////////////////////
// RG Creation //
/////////////////////////////
param Prefix int
param Environment  string
param role  string
param RGlocation  string
var deployment = '${Prefix}-${role}-${Environment}' 

module HubRG '../RG.bicep' = {
  scope:subscription()
  name: deployment
  params:{
    Prefix: Prefix
    Environment: Environment
    role: role
    RGlocation: RGlocation 

}
}

/////////////////////////////
// Log Analytics Creation //
/////////////////////////////
param Logrole string
param Log_sku string
param retention_in_days int
param log object
param metrics object
var Logdeployment = '${Prefix}-${Logrole}-${Environment}' 
var workspace_name = 'log-${Logrole}-${Environment}' // FOR DIAGNOSTIC SETTINGS

module LogAnalytics '../LogAnalytics.bicep' ={
  name: Logdeployment
  params:{
    Environment: Environment
    Logrole: Logrole
    RGlocation: RGlocation 
    retention_in_days : retention_in_days
    Log_sku: Log_sku
    log : log
    metrics: metrics
}
dependsOn: [
  HubRG
  ]
}

/////////////////////////////
// Random password Creation //
/////////////////////////////

var random_deployment = '${Prefix}-random-${KVEnvironment}'
module random '../deploymentScript.bicep' ={
 name:random_deployment
 params: {
  RGlocation: RGlocation
 }
}
/////////////////////////////
// Key Vault Creation //
/////////////////////////////
param KVEnvironment string

param KVrole string
param KVsuffix int 
param KVInfo object
param access_policies object 
@secure()
param secret object
//param networkAcls object
//param kv_log object
//param kv_metrics object
var KVdeployment = '${Prefix}-${KVrole}-${KVEnvironment}'


module KVault '../KeyVault.bicep' ={
  name: KVdeployment
  params:{
    KVrole :KVrole
    KVEnvironment :KVEnvironment
    RGlocation: RGlocation
    KVInfo: KVInfo
    //networkAcls :networkAcls
    KVsuffix: KVsuffix
    access_policies :access_policies
    secret : secret
    //LogWorkspace : workspace_name
    //kv_log: kv_log
    //kv_metrics: kv_metrics

}
}

/////////////////////////////
// SQL Creation //
/////////////////////////////
param AzSqlInfo object
param SQLrole string
param ADadmins object
param DBInfo array
param sqlfwrl object
var SQLDeployment = '${Prefix}-${SQLrole}-${Environment}'

module SQLEnv '../SQL.bicep' ={
  name:SQLDeployment
  params: {
    RGlocation: RGlocation
    Environment: Environment
    SQLrole: SQLrole
    ADadmins: ADadmins
    secretname: secret.secret1.secretName
    azSQLInfo: AzSqlInfo
    DBInfo: DBInfo
    sqlfwrl: sqlfwrl
    LogWorkspace: workspace_name
  }
 } 

and this is the module SQL created:

param azSQLInfo object
param Environment string
param LogWorkspace string
param SQLrole string
param RGlocation string
var SQL_name = 'sql-${SQLrole}-${Environment}' 
param secretname string
param ADadmins object
param DBInfo array
param sqlfwrl object


resource secret 'Microsoft.KeyVault/vaults/secrets@2022-07-01' existing = {
  name: secretname

}
resource SQL 'Microsoft.Sql/servers@2022-05-01-preview' = {
  name: SQL_name
  location: RGlocation
  properties: {
    administratorLogin: secretname
    administratorLoginPassword: secret.properties.value
    
    administrators: {
      administratorType: 'ActiveDirectory'
      login: ADadmins.username
      sid: ADadmins.object_id
      tenantId: tenant().tenantId
      principalType: ADadmins.principalType
    }
  
    version: azSQLInfo.version
    minimalTlsVersion: azSQLInfo.minimalTlsVersion
    
  }
}
resource Az_sqlfwrl 'Microsoft.Sql/servers/firewallRules@2022-02-01-preview' = [for i in items(sqlfwrl):{
  name: i.value.name
  parent: SQL
  properties: {
    startIpAddress: i.value.startIpAddress
    endIpAddress: i.value.endIpAddress
  }
}
]

resource OMS 'Microsoft.OperationalInsights/workspaces@2022-10-01' existing = {
  name: LogWorkspace
}
resource SQLDB 'Microsoft.Sql/servers/databases@2022-05-01-preview' = [for (db, index) in DBInfo: {
  name: db.Name
  parent: SQL
  location: RGlocation
  sku: {
    name: db.skuName
  }
  properties: {
    collation: db.collation
    createMode:db.createMode
    zoneRedundant:db.zoneRedundant
  }
}]


resource SQLDBDiags 'Microsoft.Insights/diagnosticSettings@2021-05-01-preview' = [for (index,db) in DBInfo: {
  name: 'service'
  scope: SQLDB[index]
  properties: {
    workspaceId: OMS.id
    logs: [
      {
        enabled: true
        category: 'SQLInsights'
      }
      {
        enabled: true
        category: 'AutomaticTuning'
      }
      {
        enabled: true
        category: 'QueryStoreRuntimeStatistics'
      }
      {
        enabled: true
        category: 'QueryStoreWaitStatistics'
      }
      {
        enabled: true
        category: 'Errors'
      }
      {
        enabled: true
        category: 'DatabaseWaitStatistics'
      }
      {
        enabled: true
        category: 'Timeouts'
      }
      {
        enabled: true
        category: 'Blocks'
      }
      {
        enabled: true
        category: 'Deadlocks'
      }
    ]
    metrics: [
      {
        category: 'Basic'
        enabled: true
        retentionPolicy: {
          enabled: false
          days: 0
        }
      }
      {
        category: 'InstanceAndAppAdvanced'
        enabled: true
        retentionPolicy: {
          enabled: false
          days: 0
        }
      }
      {
        category: 'WorkloadManagement'
        enabled: true
        retentionPolicy: {
          enabled: false
          days: 0
        }
      }
    ]
  }
}]

thank you for your help.