@hungrier
why should this be a problem?
I'm in Europe and some of our APC UPS's think that we've switched to "Summertime" ~2 Weeks ago...
/fails to see the error :-)
@hungrier
why should this be a problem?
I'm in Europe and some of our APC UPS's think that we've switched to "Summertime" ~2 Weeks ago...
/fails to see the error :-)
@iKnowItsLame said in April Fools (Re: Fuck this place):
@Gฤ ska
WUSS BOT WUSS BOT
I'm not really a bot but if something triggers me...
I can't help it!
@Gฤ
ska
and pray tell how this decision was made?
/except Blakey got Mod-Equiv and decided it wasn't open-sourcey enough (and therefore shit)
// @boomzilla everywhere gets old after a few minutes, yea...
... and my 3d-printer just finished its job:
what should I do next?
Specs: Prusa MK3s, no MMU just yet
Requirements: SFW ;-)
/hey, it's April 1st, so why not @boomzilla
@loopback0
you mean I triggered some bot?
that's awesome!
I fondly remember the time at bandcampwhere I hat to tackle some obscure error really late and G came up with "... we're experiencing some unusual requests from ... -> here's a captcha!"
/I really did look around ...
@TimeBandit
and decides to to (what?)
okay google who the <expletive> did write the book containing the aformenentioned phrase?
+1 if you can figure out with the different spell-variants.
@TimeBandit
and it CBA to provide the answer we all are looking for...
-> lame
@Tsaukpaetra
"off by two" is somewhat ...interesting..., considering I just had a
select * from openquery(linkedserver, 'select top 100 * from sometable')
-- result: 101 rows
"Yo dawg, I herd you like openquery so we wrapped ..."
@topspin
and I find it somewhat scary that this thread already shows up in google as hit #3 here...
/tinfoil-hat
@Tsaukpaetra
"der Trend zum Zweitbuch ist nicht aufzuhalten!"
Seriously: I can't find a link to the ebook right now, since I've deleted the book from my trusty Gen2-kindile I also cannot search there.
and.. I truly CBA to do a fulltext-hunt within calibre since this means I've to lift my ass and go upstairs. ;-)
anyway: ICY Kutesosh indomitable courteous <Y?>
-> I do remember this book but ... with >4K books on Kindle searching is somewhat cumbersone and I do not know you that well
you will kneel in front of Maggie (18?), Viola (15), Tinkerbell & Mika (7).
Otherwise Mika will call out to RALPH while he just happens to be in front of you shoes.
/you have been warned, strike one.
@iKnowItsLame
and now you've gone and done it and I really did confused Morbs with Blakey.
I miss them both (one just tries -and fails- to be an asshole most of the time, the other one seems to be on the spectrum and the last one belongs to our herd of cats) and therefore DEMAND that everyone gets to be Moderator.
/or else
//NO CATCARRIER
@PleegWat
yeah... noticed it just a minute after submit.
NodeBB.contains("Enterprise"), so I'll just drink some more.
I do think that @blakeyrat deserves admin-equiv anyway.
@El_Heffe said in Suddenly, I don't feel so bad about using Microsoft Office 2003:
"We will be enhancing our Web site in the coming months using Microsoft Silverlight technology."
Is there something wrong with that?
It seems to me I must have missed some memos
/I know somebody still running handheld-scanners from Symbol with DOS 5.? with TCP/IP and telnet.exe; last change I remember was to switch them from <static-IP> to DHCP, around 2005 afair. It ain't broken -> stay the hell away from it!
@loopback0
so, to sum it up: drink.
if one has to deal with <Enterprise> just drink more.
sounds allright to me
do let's close this, thanks y'all for the grins.
PS: TRWTF is the forum
the editor say <@>loopback0
live preview shows: <@>boomzilla
... at least in FF 66.0.1 64bit / Linux
@iKnowItsLame said in Oracle-Connection hangs on executing a stored proc...:
@loopback0 said in Oracle-Connection hangs on executing a stored proc...:
@iKnowItsLame said in Oracle-Connection hangs on executing a stored proc...:
so we're brothers in Stockholm, huh?
FTF
YAgain for citizens in countries with beers worth their name, otherwise you're wouldathushtwritesome gibberigobbledygook, JA?/drink and post responsibly
//one of three ain't so bad, huh?hic :-)
... or should I be supposed to grok some rules here (2 normal, rest of it green, subtracting something or not)?
-> NEIN!
Either you're drinking responsibly or you aren't; go on posting anyway
@loopback0 said in Oracle-Connection hangs on executing a stored proc...:
@iKnowItsLame said in Oracle-Connection hangs on executing a stored proc...:
so we're brothers in Stockholm, huh?
FTFYAgain for citizens in countries with beers worth their name, otherwise you're wouldathushtwritesome gibberigobbledygook, JA?
/drink and post responsibly
//one of three ain't so bad, huh?
hic :-)
so we're brothers in Stockholm, huh?
@loopback0 said in Oracle-Connection hangs on executing a stored proc...:
If only Oracle had some sort of new-fangled feature to handle this for you.
this one I can explain:
-) <Database> is "owned" by <product> with "Enterprise" in its name (hint?)
-) aforementioned <product> currently supports SQL Server >2005 and Oracle >10 as backend
-) <product> once also supported Informix and Access (or at least .mdb whateverthisshitis; not sql-server, of that I'm sure)
-> everything via ODBC, at least as far I can be bothered to remember; joined <Solution Provider> for <Vendor of product> just at the time where the last Informix-Customer left; this was ~2005 or so.
TL; DR: think of it as a CRU-Framework "...just like Oracle Forms..."; the D omitted 'cos usually one cannot (e.g. would not want to, really) "D"elete records and it's usually sufficient to just flip the table.row.deleted-column to Y.
That being said I absolutely understand the approach re "we don't want to use/support N code-paths re PK|FK and roll our own instead, our <service> handles this just fine".
... and it does; it's just when one has to leave <vendors embrace> because of (feel free to ask!) and here the aforementioned sProc comes into play.
The sProc just mimics <method_that_would_be_available_if_one_used_vendors_framework> (but can't be used 'cos nothing that came out after VB5 is officially supported, remember "Enterprise"?) and works just fine (we've implementations for MSSQL and Oracle); it's just at this one customer where the DB-Engine barfed, DEV-Instance only...
Anyway, it's quite nice to work with <Framework> once one is familiar with the ever growing list of limitations/workarounds/bugs (use <froob>, except with Builds N_to_Q -> only on Tuesdays; everything newer use <frotz> except when it doesn't work then use <froob>, YMMV; but I'm preaching to the choir here, I am posting on reddit, right?)
PS: I'm not sure if Stockholm-Syndrome applies here or if it's just "that's just like it is", my experience in this field -since 2005- points to the latter one and I've seen quite a number of <other vendors> where glossy "can do!"-papers came out as not-so-nice-"well shite, you have to code xml by hand because that's what they expect and since powers-that-be signed off, just do it"
it's quite simple:
sProc (P1 varchar INPUT, P2 number OUTPUT)...
select <col> from counter_table where table_name = P1
set P2 = <col> + 1
update counter_table set <col> = P2 where table_name = P1
return P2
/that's not PL-SQL, I know but CBA to look up the syntax used; I'm not that good at orcl-lingo and much more at home with MSSQL.
so I just exec'd this sProc a few times via SQLDeveloper and just used the PKs returned for testing; of course I had to DELETE ... them before the next run of my script but...
just to follow up / "close" this one:
-) I'm really sorry bout the and cannot explain how I manged to do that, everything looked fine in preview.
-) no I was not able to fix the timeouts on Dev-DB
... I just winged it: since the sProc in question creates/reserves PKs for <table submitted as parameter#1> (parameter#2 is the output I have to use; don't ask) I just pre-created a "free range" of PKs, used this area for test/debug and just hot-deployed this thing to Prod
-) as it is: no, no risk re "we're gonna reject this 'cos <raisins>", got a "happy customer"-feedback and I would've ignored anything else anyway.
/followup: my script (read <directory>, do some mangling with the filenames, look up in <database> and INSERT some rows according to <lookup> or not) went live with ~5 files provided by <their admin> -> all was well.
so... they decided to flip the switch on the <providing end> too:
-> the 3rd-party-thing plonked about 10K files into "my" directory; of course this happened ~5mins before <my script> was scheduled to run and while <admin> was frantically cleaning up the mess (~2K files were utter garbage) of course my script also fired... worked as expected (INSERTs got rolled back, complain in logfile and plod on...)
Summary: "works", until Prod-DB doesn't decide to ape Dev-DB's behavior I won't care about <Topic> any more. If -and when- that problem pops up my script will be the frankenstein and -hopefully- someone else's problem
//not bad for a ~6line-Spec where I had to decide the rest on my own anyway
@loopback0
"explain plan" == cost > 0 therefore WONTEXECUTE
That would be work and we can't have any of that!
.. same here: estimated: ~5hrs; actually spent: 15hrs (with ~95% done, just the effin' sProc-call fails)
-> I can't have any of that
Edit: this is not a "do my homework, please"-thing, it just really really irks me is happening here
-> will check re patch-level, if there's any difference my fellow wtf-readers already know what to expect...
@loopback0 said in Oracle-Connection hangs on executing a stored proc...:
@iKnowItsLame said in Oracle-Connection hangs on executing a stored proc...:
@loopback0 instant, nothing like > 0.01 sec
It doesn't sound like Oracle being Oracle, at least.
difficulty: on the DB refusing this I'm alone, on the working DB are ~100 users at any given time.
@boomzilla
for #1 I will have to figure out <decompiled source> actually does and then try to parrot this with PS... augh
@loopback0 instant, nothing like > 0.01 sec
@boomzilla said in Oracle-Connection hangs on executing a stored proc...:
@iKnowItsLame said in Oracle-Connection hangs on executing a stored proc...:
The one thing I've found within <frankenstein> is that this thing never calls the sProc directly and does a "insert into <blah> select sProc, whatever from dual" instead.
- Does a
select sProc...from dual
(or the same insert statement as <frankenstein>, if not) work in PS?
not tested yet, also see #3- Can you call other sProcs directly from PS?
nope- Can you call a sProc directly from <frankenstein>?
can't|won't check because I DO NOT WANT to touch this beast (lost sourcecode, decompiled, etc...) and since it does a boatload of <other things which can't be rolled back> I won't go this route, ever.
@PleegWat yes (can't doublecheck right now but DBA says yes)
EDIT: the sProcs are the identical, that I can confirm 'cos it's mine.
it works of course...
the sProc isn't anything new, the one thing that has changed is how I talk to the database (powershell vs. frankenstein .net v?); both via ODBC.
The one thing I've found within <frankenstein> is that this thing never calls the sProc directly and does a "insert into <blah> select sProc, whatever from dual" instead.
Still: this doesn't explain why it works on <thisdatabase> and doesn't on <thatdatabase>
Hi Oracle-Lovers,
this one has me quite stumped.
powershell-script simplified for repro-purposes:
$conn = New-Object System.Data.Odbc.OdbcConnection;
# PROD-DB: working
$conn.ConnectionString = "Dsn=system_dsn_name;Uid=db_user;Pwd=db_password";
# DEV-DB: hangs...
# $conn.ConnectionString = "Dsn=other_system_dsn_name;Uid=db_user;Pwd=db_password";
$conn.open();
$cmd = New-object System.Data.Odbc.OdbcCommand;
$cmd.CommandText = "call someProcedure(?, ?)";
$cmd.Connection = $conn;
$cmd.CommandType = [System.Data.CommandType]::StoredProcedure;
$p1 = $cmd.CreateParameter();
$p1.OdbcType = [System.Data.Odbc.OdbcType]::VarChar;
$p1.Size = 64;
$p1.Direction = [System.Data.ParameterDirection]::Input;
$p1.Value = "value_param_1";
$cmd.Parameters.Add($p1);
$p2 = $cmd.CreateParameter();
$p2.OdbcType = [System.Data.Odbc.OdbcType]::Numeric;
$p2.Direction = [System.Data.ParameterDirection]::InputOutput;
$p2.Value = -1;
$cmd.Parameters.Add($p2);
$cmd.ExecuteNonQuery();
Write-Host "returnValue: $($p2.Value)" -ForegroundColor Yellow;
$conn.close()
Database: 11g R2
someProcedure is an sProc with 2 parameters, the first one IN, the second one OUT.
If I execute this script as is against DatabaseOne "it's 4 o'clock and all is well"; commenting out the first ...ConnectionString and enabling the second one (different Server / Instance etc) the thing just hangs and eventually runs into a timeout.
The -not quite interested- DBA shrugs it off with "so if your newfangled powershell thingy doesn't work, huh? Then extend your <existing thing>, case closed."
Difficulty: the <existing thing> is a frankenstein worth its own which reared its head ~2005 and I absolutely do NOT want to touch.
Things I've checked:
Any ideas anyone?
@cartman82 said in Canary Tests:
SASS
Since this thread has already been necro'd:
wtf1 (?): using sass
wtf2 (definitely): using $vendor-orange as name
... so one ends up with "$vendor-orange: #008080"
/teal is the new orange?
//sounds like a S01 on netflix
@Rhywden hah... "just... everything" (duh..)
-> Board, CPU, Memory, Peripherals, just everything.. (is this a VM running on <whatever>, BareMetal, Virtualbox | VMware Player...)
I mean, it loads some of the time.
... don't faff around with the kernel, just try to find the culprit and toggle the "tryHarder"-parameter or at least the "didn't work, plod on silently and let <user> deal with it"to True.
Memory lane: one upon a time one decided to set <firewall rules> initially to "deny everything at boot" and missed the fact that <custom firewall-script> was started as last thing
-> what happened to starting ntpd (ntpdate foo.pool.ntp.org) immediately after eth0 came up is left as exercise to the reader.
/hint: since eth0 blocked everything and ntpdate hat no timeout ... ahem
@Gribnit Systemd is always a good target
/"measure at least twice, cut once" is truly a good advice.
//ensuring a replacement 8x4 -in case one accidentally b0rked the clue-bat- is available is an even better one,
///"always just change one thing, do not try a shotgun-approach" is also good; would translate into "try to recompile <kernel> without changing anything & verify boot... just to ensure that the makefiles are equivalent to <kernel that is actually running> in this case would also be a good idea.
But we shan't derail this thread with war stories...
@Rhywden do please provide more info about your kit, maybe the experience | google-fu of tdwtf unearths some gems.
"Ich habe dreimal was abgesรคgt und es ist immer noch zu kurz!"
This won't help you at all but...why did you do that?
While my exposure to linux is somewhat limited if you count the number of machines (<100 or so, that newfangled thing never got a foothold here (*)) but at least I can say that since the halcyone days of SuSe 7.x (and some faffing-around with Gentoo) I never ever recompiled a kernel myself, and never had to...
It ain't worth one's time, honestly.
-) next system-update will break something or other
-) RTL8152 / Realtek in a box that matters somehwat -> seriously? ("NE2000 with some glue" comes to mind, cannae remember where I read this)
... and so on ...
Did you ever find out what exactly is causing the stall at "mounting ..."? (I'd blame systemd anyways ;-))
... 'cos recompiling the kernel just because it could fix this (can't see how but...) seems to be the nucular option to me and therefore should be avoided at all costs.
-> you didn't -at least for me- provide enough info about your hardware to even try to dig into this but "Networking via USB" -> gah, I know you have your reasons but is -trying to- fix that really worth your time?
(*) curiously no one here has a problem running pfSense (BSD something) in a VM as a firewall-appliance, must be a GUI-vs-CLI thing...
PS: the SuSe 7.x-Box is still up-n-running, setup was initially on a1U SuperMicro P3/800 and now chuggin' along on an ESXI 6.5 with Xeon <CBA to look up>
@iKnowItsLame
Cersei, Joffrey, Tywin, NodeBB, Walder, The Hound...
-> I see the light but I'm quite afraid to advance :-D
@TimeBandit
.. still can be an oncoming train but a man can have hope, true dat.
@iKnowItsLame
and positively /me cannae grok this forum thingy...
/whatever
We have a front page?
this seems to be one of these newfangled thingamajigs which no one with onions on his belt dares to touch, ever.
@dkf ... and for the german-speaking ones here: "Cosy, so weich dass man es blind erkennt"
... which begs the question: what one does recognize while being blind ...
@Captain running "regsvr32 <path_to_LOCALY_COPIED_dll>" might be sufficient (don't forget that there can be dependencies)
anyway: procexp.exe (Sysinternals Toolkit) might be your friend.
re "why can I run the app from the client vm?":
-) 'cos it's lodged within the registry there somewhere (install-process)
-) 'cos .NET doesn't prevent <client-machine> from loading <whatever> over a fileshare (got bitten by this one for just one of the thingamajigs of the client-apps we sadly have to support; everything BUT THIS ONE THING works if one starts the client via a network-share)
-) 'cos it's an old-ass-app and INSISTS that <whatever.ini> has to reside in c:\windows\system32
If you absolutely have to get this running I've to point you to procexp.exe, an ungodly amount of elbow-grease and -can't be avoided- some "'cos it's shit!" from @blakeyrat
/loooong time lurker; you just triggered my "oh man, I'm sorry about your hassles"-nerve.
//WIBU-Key (Parallel-Port, App could not be upgraded in 2005 'cos <raisins> and we are still stuck with this 2018, how run a W2K-Server with LPT1-Passthru on ESX 6.5 / vCenter 6.5 without VCSA throwing a hissy fit? ...anyone...?)