Play Now Login Create Account
illyriad
  New Posts New Posts RSS Feed - more armies in limbo...? urgent action needed
  FAQ FAQ  Forum Search   Register Register  Login Login

more armies in limbo...? urgent action needed
 Post Reply Post Reply Page  <1 456
Author
  Topic Search Topic Search  Topic Options Topic Options
Albatross View Drop Down
Postmaster General
Postmaster General


Joined: 11 May 2011
Status: Offline
Points: 1118 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Albatross Quote  Post ReplyReply Direct Link To This Post Posted: 06 Mar 2014 at 10:48
Given that you use transactional processing, is it possible to extend the fail condition to also include a NULL test, either in the db engine or in the db-calling block?

It's nice that you're getting the support you are from software providers.

I feel very different when coding in environments that I suspect do not work as specified. All kinds of doubts creep in, and coding (or making changes) unnecessarily defensively is difficult.
Back to Top
GM Stormcrow View Drop Down
Moderator Group
Moderator Group
Avatar
GM

Joined: 23 Feb 2010
Location: Illyria
Status: Offline
Points: 3820 		Post Options Post Options   Thanks (0) Thanks(0)   Quote GM Stormcrow Quote  Post ReplyReply Direct Link To This Post Posted: 07 Mar 2014 at 10:54
Originally posted by Albatross Albatross wrote:

Given that you use transactional processing, is it possible to extend the fail condition to also include a NULL test, either in the db engine or in the db-calling block?

It's nice that you're getting the support you are from software providers.

I feel very different when coding in environments that I suspect do not work as specified. All kinds of doubts creep in, and coding (or making changes) unnecessarily defensively is difficult.
Hi albatross,

Yup, that's basically what we've put in the Stored Procs that call in, those that were definitely affected by this single instance.  As mentioned, I do broadly regard this as temporary sticky-plaster and bubblegum.

But as you rightly say, the concern is that if it's happened here and we don't yet know why... then it may also happen elsewhere in the future.  And if I have to write specific isnull handlers for every select and where statement in the codebase that looks at a NOT NULLable column, I can probably kiss goodbye to the next X months Ouch; which is why it's important the vendor is involved!

SC
Back to Top
scaramouche View Drop Down
Forum Warrior
Forum Warrior


Joined: 25 Apr 2011
Status: Offline
Points: 432 		Post Options Post Options   Thanks (0) Thanks(0)   Quote scaramouche Quote  Post ReplyReply Direct Link To This Post Posted: 07 Mar 2014 at 18:11
Originally posted by GM Stormcrow GM Stormcrow wrote:


Originally posted by Albatross Albatross wrote:


Given that you use transactional processing, is it possible to extend the fail condition to also include a NULL test, either in the db engine or in the db-calling block?

It's nice that you're getting the support you are from software providers.

I feel very different when coding in environments that I suspect do not work as specified. All kinds of doubts creep in, and coding (or making changes) unnecessarily defensively is difficult.


Hi albatross,

Yup, that's basically what we've put in the Stored Procs that <span style="line-height: 1.4;">call in, those that </span><span style="line-height: 1.4;">were definitely affected by this single instance.  As mentioned, I do broadly regard this as temporary sticky-plaster and bubblegum.</span>

But as you rightly say, the concern is that if it's happened here and we don't yet know why... then it may also happen elsewhere in the future.  And if I have to write specific isnull handlers for every select and where statement in the codebase that looks at a NOT NULLable column, I can probably kiss goodbye to the next X months Ouch; which is why it's important the vendor is involved!

SC


hmm...what with all these glitches and bugs SC...do I get a rebate on my illy membership payments?
NO..I dont do the Fandango!
Back to Top
Myr View Drop Down
Forum Warrior
Forum Warrior
Avatar

Joined: 26 May 2011
Location: Orlando, FL
Status: Offline
Points: 437 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Myr Quote  Post ReplyReply Direct Link To This Post Posted: 20 Mar 2014 at 22:45
Hey Stormcrow, I still have missing troops that haven't been returned from this whole fiasco on my alt. Since we're kind of in a heated war still it would be nice to get them back some day.

Missing troops from the Vortex
Ticket Number Category Status Assigned To Last Updated
9708 Technical Support New Unassigned 02/27/2014 01:15:37
Thanks!
Back to Top
Myr View Drop Down
Forum Warrior
Forum Warrior
Avatar

Joined: 26 May 2011
Location: Orlando, FL
Status: Offline
Points: 437 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Myr Quote  Post ReplyReply Direct Link To This Post Posted: 26 Mar 2014 at 22:44
Still unassigned. Confused
Back to Top
Myr View Drop Down
Forum Warrior
Forum Warrior
Avatar

Joined: 26 May 2011
Location: Orlando, FL
Status: Offline
Points: 437 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Myr Quote  Post ReplyReply Direct Link To This Post Posted: 11 Apr 2014 at 00:42
Thanks for letting me know you're looking into it SC. This is just a reminder that they're still missing. It would be nice to have them home  before all our cities are dust.  Thanks!
Back to Top
Ander View Drop Down
Postmaster General
Postmaster General
Avatar

Joined: 24 Apr 2011
Status: Offline
Points: 1269 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Ander Quote  Post ReplyReply Direct Link To This Post Posted: 04 May 2014 at 12:46
Armies in limbo on the tournament square, gaining tournament time. (Petition number 9910) Happened after this particular attack where there was no casualties despite a failed defence.

From: System
Subject: FW: Failed defense by Mariabronne's forces at [400|-504] in Turalia under attack by h2Oxy's forces from Lovely
Received: 04 May 2014 10:55
Original Message:
Two opposing forces clash against each other.

Cavalry comes into its own when able to strike hostile forces at will, and from unexpected directions - and nowhere is this more feasible than on open plains. Lightly armoured spear units, however, prefer terrain where there's some cover available.

Fighting defensively on open plains, cavalry draws strength from the ability to form and reform their lines of engagement depending on the direction of battle, and it is here where cavalry excels.

Attackers:Unit:Quantity:Casualties:Survivors:
Troops:Charioteers Charioteers77077
Commander: NewerKnightKnights Knight1Damaged for 0, 100 health remains.
Troops:Knights Knights3320332


Defenders:Unit:Quantity:Casualties:Survivors:
Commander: Commander 2Swiftsteeds Swiftsteed1Damaged for 100, 0 health remains.
Troops:Swiftsteeds Swiftsteeds101
Back to Top
Ander View Drop Down
Postmaster General
Postmaster General
Avatar

Joined: 24 Apr 2011
Status: Offline
Points: 1269 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Ander Quote  Post ReplyReply Direct Link To This Post Posted: 04 May 2014 at 14:02
All the limbo armies were destroyed in the last attack.

Your army was driven back and enemy units have taken control of this location.

Your defending army was entirely destroyed at [400|-504] in Turalia by h2Oxy's forces from AquaFire

Attackers:Unit:Quantity:Casualties:Survivors:
Commander: KnightTaukeyKnights Knight1Damaged for 0, 150 health remains.
Troops:Knights Knights3260326


Defenders:Unit:Quantity:Casualties:Survivors:
Troops:Swiftsteeds Swiftsteeds110
Troops:Swiftsteeds Swiftsteeds110
Commander: Commander 2Swiftsteeds Swiftsteed1Damaged for 100, 0 health remains.
Troops:Swiftsteeds Swiftsteeds110
Back to Top
 Post Reply Post Reply Page  <1 456
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.