__STEP
   langid="it"
   visp="simonlib"
   country=null
   conf="simonlib-bsitalia/user"
   curr="login"
   module="user"

charts
   colors
      bars="1637a4,970f36,c2c400,339e0e,d44100,1b6e95,8e1096,6d6d6d,1d48d5,c91548,dde000,3fbe12,fc4700,238bbb,b214bc,818181,3b63e5,e81e57,fcf900,4ce616,ff652f,32a5da,d319df,979797,6786eb,ee4676,fffd2f,6bed3d,ff8863,4bb0df,e143eb,acacac,8fa6f1,f37397,fffd67,8df26a,ffb39f,86caea,e86cf0,c5c5c5"
      hbars="1637a4,970f36,c2c400,339e0e,d44100,1b6e95,8e1096,6d6d6d,1d48d5,c91548,dde000,3fbe12,fc4700,238bbb,b214bc,818181,3b63e5,e81e57,fcf900,4ce616,ff652f,32a5da,d319df,979797,6786eb,ee4676,fffd2f,6bed3d,ff8863,4bb0df,e143eb,acacac,8fa6f1,f37397,fffd67,8df26a,ffb39f,86caea,e86cf0,c5c5c5"
      pies="1637a4,970f36,c2c400,339e0e,d44100,1b6e95,8e1096,6d6d6d,1d48d5,c91548,dde000,3fbe12,fc4700,238bbb,b214bc,818181,3b63e5,e81e57,fcf900,4ce616,ff652f,32a5da,d319df,979797,6786eb,ee4676,fffd2f,6bed3d,ff8863,4bb0df,e143eb,acacac,8fa6f1,f37397,fffd67,8df26a,ffb39f,86caea,e86cf0,c5c5c5"
      lines="1637a4,970f36,c2c400,339e0e,d44100,1b6e95,8e1096,6d6d6d,1d48d5,c91548,dde000,3fbe12,fc4700,238bbb,b214bc,818181,3b63e5,e81e57,fcf900,4ce616,ff652f,32a5da,d319df,979797,6786eb,ee4676,fffd2f,6bed3d,ff8863,4bb0df,e143eb,acacac,8fa6f1,f37397,fffd67,8df26a,ffb39f,86caea,e86cf0,c5c5c5"
      splines="1637a4,970f36,c2c400,339e0e,d44100,1b6e95,8e1096,6d6d6d,1d48d5,c91548,dde000,3fbe12,fc4700,238bbb,b214bc,818181,3b63e5,e81e57,fcf900,4ce616,ff652f,32a5da,d319df,979797,6786eb,ee4676,fffd2f,6bed3d,ff8863,4bb0df,e143eb,acacac,8fa6f1,f37397,fffd67,8df26a,ffb39f,86caea,e86cf0,c5c5c5"
usedb="mysql"
adminuser
   enabled="yes"
   username="superuser"
   password="298c476c44"
libraries
   registration_code="solo.per.noi"
ALL_RIGHTS_PATTERN="33554431"
env="dev"
autoupdate
   url="http://www.simonlib.com/patches/25/simonlib.ini"
   autoreg="http://licenses.simonlib.it/licenses?entry=autoreg"
   interval="3600000"
   timeout="60000"
sql
   sql-quote-replace="''"
   tostring1=" "
   tostring2=" "
   schema-quote="`"
   dateA="'"
   dateB="'"
   yearA="YEAR("
   yearB=")"
   monthA="MONTH("
   monthB=")"
   dayA="DAY("
   dayB=")"
   dbdate="yyyy-MM-dd HH:mm:ss.S"
   delete="DELETE"
   is_null=" IS NULL"
   primary=" "
   storage=" TYPE=InnoDB"
   datetime="datetime"
   double="DECIMAL(28,15)"
   memotype="text"
   varchar="varchar"
   distinctlong="text"
   castnum1="CAST("
   castnum2=" AS DECIMAL(19,2))"
   castdecimalsA=" "
   castdecimalsB=" "
   add1=" CONCAT("
   addsep=","
   add2=")"
   lenght="LENGTH"
   limitSQLServer=" "
   limitRest=" LIMIT "
   limitSQLServer1=" "
   limitRest1=" LIMIT 1 "
   bitandA="("
   bitandB="&"
   bitandC=")"
   bitorA="("
   bitorB="|"
   bitorC=")"
   notA="(CASE "
   notB=" WHEN 0 THEN 1 ELSE 0 END)"
   caseA="(CASE "
   caseB=" WHEN "
   caseC=" THEN "
   caseD=" ELSE "
   caseE=" END)"
   orderby=" "
   orderbyDesc=" "
   escape_und1="\_"
   escape_und2=" "
   filters
      languages
         table_name="`descriptions`"
         queryTagID="(JD|DJ|D2J)[0-9]+"
         query="@TLABEL@`IDUnique` IS NULL OR @TLABEL@`IDUnique`= ANY (SELECT JD%.`IDUnique` FROM `descriptions` JD% 
									INNER JOIN (SELECT D2J%.`ID`, max((D2J%.`FkLanguage`&@LID1@)) 
																+ (((CASE max((D2J%.`FkLanguage`&@LID1@)) WHEN 0 THEN 1 ELSE 0 END)) * (max((D2J%.`FkLanguage`&@LID2@)))) 
																+ (((CASE max((D2J%.`FkLanguage`&@LID1@)) + max((D2J%.`FkLanguage`&@LID2@)) WHEN 0 THEN 1 ELSE 0 END)) * max(D2J%.`FkLanguage`)) AS `FkLanguage`
						            				FROM `descriptions` D2J% GROUP BY D2J%.`ID`) DJ% ON (JD%.`ID`=DJ%.`ID` AND JD%.`FkLanguage`=DJ%.`FkLanguage`)
						            WHERE @TLABEL@`ID`=JD%.`ID`)"
      libraries
         table_name="`libraries`"
         queryTagID="JL[0-9]+"
         query="@TLABEL@`IDUnique` IS NULL OR @TLABEL@`IDUnique`= ANY (SELECT `ID`+2000*(`ID`-10000)+(CASE MAX(`LYear`) WHEN 0 THEN 0 ELSE MAX(`LYear`)-1899 END) FROM `libraries` JL% WHERE JL%.`LYear`<=@YEAR@ AND @TLABEL@`ID`=JL%.`ID` GROUP BY JL%.`ID`)"
      hierarchy
         table_name="`library_views`"
         queryTagID="JLV[0-9]+"
         query="@TLABEL@`IDUnique` IS NULL OR @TLABEL@`IDUnique`= ANY (SELECT `FkLibrary`+2000*(`FkLibrary`-10000)+(CASE MAX(`LYear`) WHEN 0 THEN 0 ELSE MAX(`LYear`)-1899 END) FROM `library_views` JLV% WHERE JLV%.`LYear`<=@YEAR@ AND @TLABEL@`FkLibrary`=JLV%.`FkLibrary` GROUP BY JLV%.`FkLibrary`)"
      thresholds
         table_name="`thresholds`"
         queryTagID="(JTE|ETJ)[0-9]+"
         query="@TLABEL@`ID` IS NULL OR @TLABEL@`ID`= ANY (SELECT `ID` FROM `thresholds` JTE% 
																INNER JOIN (SELECT `FkIndex`, MAX(`TYear`) AS `TYear`, `FkRangePar`, `FkSubRangeDesc` 
																				FROM `thresholds` JT% 
																				WHERE JT%.`TYear`<=@YEAR@ 
																				GROUP BY JT%.`FkIndex`,JT%.`FkRangePar`,JT%.`FkSubRangeDesc`) ETJ% 
																			ON (JTE%.`FkIndex`=ETJ%.`FkIndex` AND JTE%.`TYear`=ETJ%.`TYear` AND JTE%.`FkRangePar`=ETJ%.`FkRangePar` AND ((JTE%.`FkSubRangeDesc` IS NULL AND ETJ%.`FkSubRangeDesc` IS NULL) OR JTE%.`FkSubRangeDesc`=ETJ%.`FkSubRangeDesc`)) 
															WHERE JTE%.`FkIndex`=@TLABEL@`FkIndex` AND JTE%.`TYear`=@TLABEL@`TYear` AND JTE%.`FkRangePar`=@TLABEL@`FkRangePar` AND ((JTE%.`FkSubRangeDesc` IS NULL AND @TLABEL@`FkSubRangeDesc` IS NULL) OR JTE%.`FkSubRangeDesc`=@TLABEL@`FkSubRangeDesc`)
															)"
   unique-id-violation-message-retry="Duplicate entry 
'"
   lockA="LOCK TABLES "
   lockB=" WRITE"
   unlockA="UNLOCK TABLES"
   datediffA="DATEDIFF("
   datediffB=")"
   strtodateA="STR_TO_DATE("
   strtodateB=", '%Y-%M-%d')"
   timediffA="TIMEDIFF("
   timediffB=")"
   timeformatA="TIME_FORMAT("
   timeformatB=", '%H:%i')"
   timetosecA="TIME_TO_SEC("
   timetosecB=")"
   weekA="WEEK("
   weekB=", 1)"
   concatA="CONCAT("
   concatB=")"
   roundA="ROUND("
   roundB=", 2)"
init_error="1"
_OS_="linux"
database
   jdbc-driver="com.mysql.jdbc.Driver"
   jdbc-connect="jdbc:mysql://127.0.0.1:3306/musei?user=simonlib&password=298c476c44&zeroDateTimeBehavior=convertToNull&characterEncoding=utf8"
   enckey="NyZB6u8U9w5W&L7W!u2A2SAZ#!3B6EACQKqrMxtqq78MzhnAYj"
   libraries
      councillabels="0"
   languages
      smart_shema="0"
system
   use-version="2.0"
   xsl-error-page="generic-error"
   localization-path="yes"
   log-filename="systrace.log"
   debug="yes"
   development="yes"
   cache-application="no"
   cache-validation="yes"
   cache-graphic="no"
   data-compression="-1"
   split-country-graphicyes="yes"
   split-visp-graphic="no"
_project_path="/opt/xsapps/tomcat/webapps/musei-bsit"
p3p-header="CP="CAO DSP COR CURa ADMa DEVa OUR IND PHY ONL UNI COM NAV INT DEM PRE""
bridge
   state="1"
fields
   09="0123456789"
   az="abcdefghijklmnopqrstuvwxyzäöü"
   AZ="ABCDEFGHIJKLMNOPQRSTUVWXYZÄÖÜ"
   Az="abcdefghijklmnopqrstuvwxyzäöüABCDEFGHIJKLMNOPQRSTUVWXYZÄÖÜ"
   Az09="abcdefghijklmnopqrstuvwxyzäöüABCDEFGHIJKLMNOPQRSTUVWXYZÄÖÜ0123456789"
   Az09special="abcdefghijklmnopqrstuvwxyzäöüABCDEFGHIJKLMNOPQRSTUVWXYZÄÖÜ0123456789_-."
   email="abcdefghijklmnopqrstuvwxyzäöüABCDEFGHIJKLMNOPQRSTUVWXYZÄÖÜ0123456789_-.@"
   name="abcdefghijklmnopqrstuvwxyzäöüABCDEFGHIJKLMNOPQRSTUVWXYZÄÖÜ ìòàèéù"

<page app-path="/simonlib-bsitalia/" country="" is-debug="yes" is-dev="yes" lang-id="it" module="simonlib-bsitalia/user" name="login" port="443" server="musei-bsit.staging-001.simonlib.net" visp="simonlib" xsl-file="generic-error">
    <exception><db-query convert="value" out="$scope" sql="SELECT ID FROM scopes WHERE Name = {sqlq($name)}">

java.lang.Exception: 
Impossible resolveValue [mod_main.load()]: 
Impossible resolveValueObj [main.getInstanceDocs(_GYEAR)]: 
Impossible resolveValueObj [$scope = getScopeId('instance-docs')]: Access denied for user 'simonlib'@'172.18.0.1' (using password: YES)
	at com.formprocessor.core.MapHelper.resolveValueA(MapHelper.java:441)
	at com.formprocessor.core.MapHelper.resolveValue(MapHelper.java:293)
	at com.formprocessor.core.api.API_call_method.execute(API_call_method.java:37)
	at com.formprocessor.core.api.API_call_method.doXmlAction(API_call_method.java:22)
	at com.formprocessor.core.Processor.doInnerProcess(Processor.java:187)
	at com.formprocessor.core.Processor.doProcess(Processor.java:109)
	at com.formprocessor.core.Processor.doProcess(Processor.java:71)
	at com.formprocessor.core.HttpStateless.doStepExecution(HttpStateless.java:408)
	at com.formprocessor.core.Step.setCurrentNode(Step.java:309)
	at com.formp</exception>
    <data>eJw=ZYw7TgMxEIb/LNkkPIrQJKcgNPTQEIHES4IKRQqTtckaHHvxjMPScCIOEcQJaLkDJ6DBK4EoGGlmpP/7Zl4+kXPA8I6WNIpi7OjEuHutjojLU6r2VmeTvl19ZWhdY5OKQjOfB6VDHbD9d/Nj592P17fBzfsasjE2rCc1pkJ8OMa6lEFz6a2qq/0DNLX12Euzn7ol6Eynl1eHF/yAZ+Cf0EmCJTc3SpAZEbSXhitBj83CO2tmgm7ho5PwlNJ24d2tYPALd2ZshKyh3cg6NDyGtHLr58alzwuvotUpb3CNGt/CAVMV</data>
</page>

generic-error