Streets Version Update

Update maptiler

Users will need to update the Streets URL to Streets-v2. Be sure to empty the map tile cache folder first to test.\ \Users\\AppData\Local\Temp\Arkieva\MapCacheData

• https://cloud.maptiler.com/auth/widget?next=https://cloud.maptiler.com/maps/
• https://docs.maptiler.com/guides/map-design/maps-and-styles-basics/

Arkieva databases procedures

Need a way to have pr_Sys_Procedure_Source on Arkieva databases as a default procedure

We had [pr_Sys_Procedure_Source] procedure in our old databases that was pretty good to use for investigating and scanning tables, views, procs, jobs etc. The following is an easier way to query the database.

Old process:

EXEC [pr_Sys_Procedure_Source]    <databasename>

SELECT DISTINCT obj_name

FROM dbo.zt_HelpText

WHERE [Text] LIKE '%abc %'

New Process:

[PrsProcedureSource]

SELECT b.[OBJName], a.Txt

FROM TMPPrsProcedureSourceF   a

JOIN TMPPrsProcedureSourceE b ON a.[ObjID] = b.[ObjID]     

WHERE Txt LIKE '%ztb_Scenario_Properties%'

Item Group

Hyperlink Behavior

Previously, when using the save layout option with Item Groups comprised of a table editor and a quick report, clicking hyperlinks to quick reports as a filtered popup would launch a brand new version of the quick report, losing any new saved layouts in the table with a filtered quick report.

Now, when clicking on a hyperlink, the system will check if the link destination is already in the item group. If so, the quick report will not be relaunched to complete the process, and will instead use the quick report already opened in the item group.

XPRESS

MAXTIME Depreciated in XPRESS

TIMELIMIT will now replace MAXTIME in XPRESS. Arkieva now ships with the TIMELIMIT parameter with the same value of 1800 which has the same effect. This only applies to versions of Arkieva where we ship XPRESS version 9.0 or higher. Below is the writeup from the XPRESS manual (XPRESS version 9.0).

TIMELIMIT is the maximum time in seconds that the Optimizer will run before it terminates, including the problem setup time and solution time. For MIP problems, this is the total time taken to solve all nodes.

• Type: Double
• Values: >0 Stop LP or MIP search after the given number of seconds.
• Default value: 1e+20
• Note: This control has been newly introduced with Xpress Optimizer version 9.0 and should be used instead of the deprecated MAXTIME control. Note that the meaning of positive values differs between TIMELIMIT and MAXTIME. When both controls are set, TIMELIMIT takes precedence. The functionality of positive MAXTIME values is covered by SOLTIMELIMIT.
• Affects Routines: XPRSlpoptimize (LPOPTIMIZE), XPRSmipoptimize (MIPOPTIMIZE).

See also: SOLTIMELIMIT.